Violation of PRIMARY KEY constraint 'PK__OPERATORS_1__4155D256'. Cannot insert duplicate key in object 'dbo.OPERATORS'.
The statement has been terminated.

#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:2.0.50727.4206
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace datamigrate.testsrv
{
	using System.Data.Linq;
	using System.Data.Linq.Mapping;
	using System.Data;
	using System.Collections.Generic;
	using System.Reflection;
	using System.Linq;
	using System.Linq.Expressions;
	using System.ComponentModel;
	using System;
	
	
	[System.Data.Linq.Mapping.DatabaseAttribute(Name="Mkassa")]
	public partial class DataClassesTestservDataContext : System.Data.Linq.DataContext
	{
		
		private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
		
    #region Extensibility Method Definitions
    partial void OnCreated();
    partial void InsertOPERATOR(OPERATOR instance);
    partial void UpdateOPERATOR(OPERATOR instance);
    partial void DeleteOPERATOR(OPERATOR instance);
    #endregion
		
		public DataClassesTestservDataContext() : 
				base(global::datamigrate.Properties.Settings.Default.MkassaConnectionString, mappingSource)
		{
			OnCreated();
		}
		
		public DataClassesTestservDataContext(string connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public DataClassesTestservDataContext(System.Data.IDbConnection connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public DataClassesTestservDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public DataClassesTestservDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public System.Data.Linq.Table<OPERATOR> OPERATORs
		{
			get
			{
				return this.GetTable<OPERATOR>();
			}
		}
	}
	
	[Table(Name="dbo.OPERATORS")]
	public partial class OPERATOR : INotifyPropertyChanging, INotifyPropertyChanged
	{
		
		private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
		
		private int _ID;
		
		private int _CODE;
		
		private string _NAME;
		
		private System.Nullable<int> _TYPE;
		
		private System.Nullable<bool> _STATE;
		
		private System.Nullable<int> _GATEWAY_ID;
		
		private int _MAXLEN;
		
		private string _NOTE;
		
		private string _expression;
		
		private int _DIRECT_GATEWAY;
		
		private string _OPER_NAME;
		
		private string _UR_FACE;
		
		private System.Nullable<int> _OPER_TYPE;
		
		private int _MIN_PAY;
		
		private int _MAX_PAY;
		
		private string _COMISSIA;
		
		private string _mask;
		
		private int _account;
		
		private string _INN;
		
		private int _RepealDayCount;
		
		private int _RepealMinSumma;
		
		private string _Message;
		
		private bool _blocked;
		
		private string _phone;
		
		private string _web;
		
		private string _contract;
		
    #region Extensibility Method Definitions
    partial void OnLoaded();
    partial void OnValidate(System.Data.Linq.ChangeAction action);
    partial void OnCreated();
    partial void OnIDChanging(int value);
    partial void OnIDChanged();
    partial void OnCODEChanging(int value);
    partial void OnCODEChanged();
    partial void OnNAMEChanging(string value);
    partial void OnNAMEChanged();
    partial void OnTYPEChanging(System.Nullable<int> value);
    partial void OnTYPEChanged();
    partial void OnSTATEChanging(System.Nullable<bool> value);
    partial void OnSTATEChanged();
    partial void OnGATEWAY_IDChanging(System.Nullable<int> value);
    partial void OnGATEWAY_IDChanged();
    partial void OnMAXLENChanging(int value);
    partial void OnMAXLENChanged();
    partial void OnNOTEChanging(string value);
    partial void OnNOTEChanged();
    partial void OnexpressionChanging(string value);
    partial void OnexpressionChanged();
    partial void OnDIRECT_GATEWAYChanging(int value);
    partial void OnDIRECT_GATEWAYChanged();
    partial void OnOPER_NAMEChanging(string value);
    partial void OnOPER_NAMEChanged();
    partial void OnUR_FACEChanging(string value);
    partial void OnUR_FACEChanged();
    partial void OnOPER_TYPEChanging(System.Nullable<int> value);
    partial void OnOPER_TYPEChanged();
    partial void OnMIN_PAYChanging(int value);
    partial void OnMIN_PAYChanged();
    partial void OnMAX_PAYChanging(int value);
    partial void OnMAX_PAYChanged();
    partial void OnCOMISSIAChanging(string value);
    partial void OnCOMISSIAChanged();
    partial void OnmaskChanging(string value);
    partial void OnmaskChanged();
    partial void OnaccountChanging(int value);
    partial void OnaccountChanged();
    partial void OnINNChanging(string value);
    partial void OnINNChanged();
    partial void OnRepealDayCountChanging(int value);
    partial void OnRepealDayCountChanged();
    partial void OnRepealMinSummaChanging(int value);
    partial void OnRepealMinSummaChanged();
    partial void OnMessageChanging(string value);
    partial void OnMessageChanged();
    partial void OnblockedChanging(bool value);
    partial void OnblockedChanged();
    partial void OnphoneChanging(string value);
    partial void OnphoneChanged();
    partial void OnwebChanging(string value);
    partial void OnwebChanged();
    partial void OncontractChanging(string value);
    partial void OncontractChanged();
    #endregion
		
		public OPERATOR()
		{
			OnCreated();
		}
		
		[Column(Storage="_ID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
		public int ID
		{
			get
			{
				return this._ID;
			}
			set
			{
				if ((this._ID != value))
				{
					this.OnIDChanging(value);
					this.SendPropertyChanging();
					this._ID = value;
					this.SendPropertyChanged("ID");
					this.OnIDChanged();
				}
			}
		}
		
		[Column(Storage="_CODE", DbType="Int NOT NULL")]
		public int CODE
		{
			get
			{
				return this._CODE;
			}
			set
			{
				if ((this._CODE != value))
				{
					this.OnCODEChanging(value);
					this.SendPropertyChanging();
					this._CODE = value;
					this.SendPropertyChanged("CODE");
					this.OnCODEChanged();
				}
			}
		}
		
		[Column(Storage="_NAME", DbType="VarChar(100)")]
		public string NAME
		{
			get
			{
				return this._NAME;
			}
			set
			{
				if ((this._NAME != value))
				{
					this.OnNAMEChanging(value);
					this.SendPropertyChanging();
					this._NAME = value;
					this.SendPropertyChanged("NAME");
					this.OnNAMEChanged();
				}
			}
		}
		
		[Column(Storage="_TYPE", DbType="Int")]
		public System.Nullable<int> TYPE
		{
			get
			{
				return this._TYPE;
			}
			set
			{
				if ((this._TYPE != value))
				{
					this.OnTYPEChanging(value);
					this.SendPropertyChanging();
					this._TYPE = value;
					this.SendPropertyChanged("TYPE");
					this.OnTYPEChanged();
				}
			}
		}
		
		[Column(Storage="_STATE", DbType="Bit")]
		public System.Nullable<bool> STATE
		{
			get
			{
				return this._STATE;
			}
			set
			{
				if ((this._STATE != value))
				{
					this.OnSTATEChanging(value);
					this.SendPropertyChanging();
					this._STATE = value;
					this.SendPropertyChanged("STATE");
					this.OnSTATEChanged();
				}
			}
		}
		
		[Column(Storage="_GATEWAY_ID", DbType="Int")]
		public System.Nullable<int> GATEWAY_ID
		{
			get
			{
				return this._GATEWAY_ID;
			}
			set
			{
				if ((this._GATEWAY_ID != value))
				{
					this.OnGATEWAY_IDChanging(value);
					this.SendPropertyChanging();
					this._GATEWAY_ID = value;
					this.SendPropertyChanged("GATEWAY_ID");
					this.OnGATEWAY_IDChanged();
				}
			}
		}
		
		[Column(Storage="_MAXLEN", DbType="Int NOT NULL")]
		public int MAXLEN
		{
			get
			{
				return this._MAXLEN;
			}
			set
			{
				if ((this._MAXLEN != value))
				{
					this.OnMAXLENChanging(value);
					this.SendPropertyChanging();
					this._MAXLEN = value;
					this.SendPropertyChanged("MAXLEN");
					this.OnMAXLENChanged();
				}
			}
		}
		
		[Column(Storage="_NOTE", DbType="VarChar(255)")]
		public string NOTE
		{
			get
			{
				return this._NOTE;
			}
			set
			{
				if ((this._NOTE != value))
				{
					this.OnNOTEChanging(value);
					this.SendPropertyChanging();
					this._NOTE = value;
					this.SendPropertyChanged("NOTE");
					this.OnNOTEChanged();
				}
			}
		}
		
		[Column(Storage="_expression", DbType="VarChar(255) NOT NULL", CanBeNull=false)]
		public string expression
		{
			get
			{
				return this._expression;
			}
			set
			{
				if ((this._expression != value))
				{
					this.OnexpressionChanging(value);
					this.SendPropertyChanging();
					this._expression = value;
					this.SendPropertyChanged("expression");
					this.OnexpressionChanged();
				}
			}
		}
		
		[Column(Storage="_DIRECT_GATEWAY", DbType="Int NOT NULL")]
		public int DIRECT_GATEWAY
		{
			get
			{
				return this._DIRECT_GATEWAY;
			}
			set
			{
				if ((this._DIRECT_GATEWAY != value))
				{
					this.OnDIRECT_GATEWAYChanging(value);
					this.SendPropertyChanging();
					this._DIRECT_GATEWAY = value;
					this.SendPropertyChanged("DIRECT_GATEWAY");
					this.OnDIRECT_GATEWAYChanged();
				}
			}
		}
		
		[Column(Storage="_OPER_NAME", DbType="VarChar(50)")]
		public string OPER_NAME
		{
			get
			{
				return this._OPER_NAME;
			}
			set
			{
				if ((this._OPER_NAME != value))
				{
					this.OnOPER_NAMEChanging(value);
					this.SendPropertyChanging();
					this._OPER_NAME = value;
					this.SendPropertyChanged("OPER_NAME");
					this.OnOPER_NAMEChanged();
				}
			}
		}
		
		[Column(Storage="_UR_FACE", DbType="VarChar(255)")]
		public string UR_FACE
		{
			get
			{
				return this._UR_FACE;
			}
			set
			{
				if ((this._UR_FACE != value))
				{
					this.OnUR_FACEChanging(value);
					this.SendPropertyChanging();
					this._UR_FACE = value;
					this.SendPropertyChanged("UR_FACE");
					this.OnUR_FACEChanged();
				}
			}
		}
		
		[Column(Storage="_OPER_TYPE", DbType="Int")]
		public System.Nullable<int> OPER_TYPE
		{
			get
			{
				return this._OPER_TYPE;
			}
			set
			{
				if ((this._OPER_TYPE != value))
				{
					this.OnOPER_TYPEChanging(value);
					this.SendPropertyChanging();
					this._OPER_TYPE = value;
					this.SendPropertyChanged("OPER_TYPE");
					this.OnOPER_TYPEChanged();
				}
			}
		}
		
		[Column(Storage="_MIN_PAY", DbType="Int NOT NULL")]
		public int MIN_PAY
		{
			get
			{
				return this._MIN_PAY;
			}
			set
			{
				if ((this._MIN_PAY != value))
				{
					this.OnMIN_PAYChanging(value);
					this.SendPropertyChanging();
					this._MIN_PAY = value;
					this.SendPropertyChanged("MIN_PAY");
					this.OnMIN_PAYChanged();
				}
			}
		}
		
		[Column(Storage="_MAX_PAY", DbType="Int NOT NULL")]
		public int MAX_PAY
		{
			get
			{
				return this._MAX_PAY;
			}
			set
			{
				if ((this._MAX_PAY != value))
				{
					this.OnMAX_PAYChanging(value);
					this.SendPropertyChanging();
					this._MAX_PAY = value;
					this.SendPropertyChanged("MAX_PAY");
					this.OnMAX_PAYChanged();
				}
			}
		}
		
		[Column(Storage="_COMISSIA", DbType="VarChar(200)")]
		public string COMISSIA
		{
			get
			{
				return this._COMISSIA;
			}
			set
			{
				if ((this._COMISSIA != value))
				{
					this.OnCOMISSIAChanging(value);
					this.SendPropertyChanging();
					this._COMISSIA = value;
					this.SendPropertyChanged("COMISSIA");
					this.OnCOMISSIAChanged();
				}
			}
		}
		
		[Column(Storage="_mask", DbType="VarChar(200)")]
		public string mask
		{
			get
			{
				return this._mask;
			}
			set
			{
				if ((this._mask != value))
				{
					this.OnmaskChanging(value);
					this.SendPropertyChanging();
					this._mask = value;
					this.SendPropertyChanged("mask");
					this.OnmaskChanged();
				}
			}
		}
		
		[Column(Storage="_account", DbType="Int NOT NULL")]
		public int account
		{
			get
			{
				return this._account;
			}
			set
			{
				if ((this._account != value))
				{
					this.OnaccountChanging(value);
					this.SendPropertyChanging();
					this._account = value;
					this.SendPropertyChanged("account");
					this.OnaccountChanged();
				}
			}
		}
		
		[Column(Storage="_INN", DbType="VarChar(20)")]
		public string INN
		{
			get
			{
				return this._INN;
			}
			set
			{
				if ((this._INN != value))
				{
					this.OnINNChanging(value);
					this.SendPropertyChanging();
					this._INN = value;
					this.SendPropertyChanged("INN");
					this.OnINNChanged();
				}
			}
		}
		
		[Column(Storage="_RepealDayCount", DbType="Int NOT NULL")]
		public int RepealDayCount
		{
			get
			{
				return this._RepealDayCount;
			}
			set
			{
				if ((this._RepealDayCount != value))
				{
					this.OnRepealDayCountChanging(value);
					this.SendPropertyChanging();
					this._RepealDayCount = value;
					this.SendPropertyChanged("RepealDayCount");
					this.OnRepealDayCountChanged();
				}
			}
		}
		
		[Column(Storage="_RepealMinSumma", DbType="Int NOT NULL")]
		public int RepealMinSumma
		{
			get
			{
				return this._RepealMinSumma;
			}
			set
			{
				if ((this._RepealMinSumma != value))
				{
					this.OnRepealMinSummaChanging(value);
					this.SendPropertyChanging();
					this._RepealMinSumma = value;
					this.SendPropertyChanged("RepealMinSumma");
					this.OnRepealMinSummaChanged();
				}
			}
		}
		
		[Column(Storage="_Message", DbType="VarChar(2048)")]
		public string Message
		{
			get
			{
				return this._Message;
			}
			set
			{
				if ((this._Message != value))
				{
					this.OnMessageChanging(value);
					this.SendPropertyChanging();
					this._Message = value;
					this.SendPropertyChanged("Message");
					this.OnMessageChanged();
				}
			}
		}
		
		[Column(Storage="_blocked", DbType="Bit NOT NULL")]
		public bool blocked
		{
			get
			{
				return this._blocked;
			}
			set
			{
				if ((this._blocked != value))
				{
					this.OnblockedChanging(value);
					this.SendPropertyChanging();
					this._blocked = value;
					this.SendPropertyChanged("blocked");
					this.OnblockedChanged();
				}
			}
		}
		
		[Column(Storage="_phone", DbType="VarChar(50) NOT NULL", CanBeNull=false)]
		public string phone
		{
			get
			{
				return this._phone;
			}
			set
			{
				if ((this._phone != value))
				{
					this.OnphoneChanging(value);
					this.SendPropertyChanging();
					this._phone = value;
					this.SendPropertyChanged("phone");
					this.OnphoneChanged();
				}
			}
		}
		
		[Column(Storage="_web", DbType="VarChar(50) NOT NULL", CanBeNull=false)]
		public string web
		{
			get
			{
				return this._web;
			}
			set
			{
				if ((this._web != value))
				{
					this.OnwebChanging(value);
					this.SendPropertyChanging();
					this._web = value;
					this.SendPropertyChanged("web");
					this.OnwebChanged();
				}
			}
		}
		
		[Column(Storage="_contract", DbType="VarChar(1024) NOT NULL", CanBeNull=false)]
		public string contract
		{
			get
			{
				return this._contract;
			}
			set
			{
				if ((this._contract != value))
				{
					this.OncontractChanging(value);
					this.SendPropertyChanging();
					this._contract = value;
					this.SendPropertyChanged("contract");
					this.OncontractChanged();
				}
			}
		}
		
		public event PropertyChangingEventHandler PropertyChanging;
		
		public event PropertyChangedEventHandler PropertyChanged;
		
		protected virtual void SendPropertyChanging()
		{
			if ((this.PropertyChanging != null))
			{
				this.PropertyChanging(this, emptyChangingEventArgs);
			}
		}
		
		protected virtual void SendPropertyChanged(String propertyName)
		{
			if ((this.PropertyChanged != null))
			{
				this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
			}
		}
	}
}
#pragma warning restore 1591

USE [Mkassa]
GO

/****** Object:  Table [dbo].[OPERATORS]    Script Date: 08/30/2010 12:41:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[OPERATORS](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[code] [int] NOT NULL,
	[NAME] [varchar](100) NULL,
	[TYPE] [int] NULL,
	[STATE] [bit] NULL,
	[GATEWAY_ID] [int] NULL,
	[MAXLEN] [int] NOT NULL,
	[NOTE] [varchar](255) NULL,
	[expression] [varchar](255) NOT NULL,
	[DIRECT_GATEWAY] [int] NOT NULL,
	[OPER_NAME] [varchar](50) NULL,
	[UR_FACE] [varchar](255) NULL,
	[OPER_TYPE] [int] NULL,
	[MIN_PAY] [int] NOT NULL,
	[MAX_PAY] [int] NOT NULL,
	[COMISSIA] [varchar](200) NULL,
	[mask] [varchar](200) NULL,
	[account] [int] NOT NULL,
	[INN] [varchar](20) NULL,
	[RepealDayCount] [int] NOT NULL,
	[RepealMinSumma] [int] NOT NULL,
	[Message] [varchar](2048) NULL,
	[blocked] [bit] NOT NULL,
	[phone] [varchar](50) NOT NULL,
	[web] [varchar](50) NOT NULL,
	[contract] [varchar](1024) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO