mcs/class/System.Data.Linq/examples/DbLinq.SQLite.Example/nwind/Northwind.cs

   1 #region Auto-generated classes for Northwind database on [TIMESTAMP]\r
   2 \r
   3 //\r
   4 //  ____  _     __  __      _        _\r
   5 // |  _ \| |__ |  \/  | ___| |_ __ _| |\r
   6 // | | | | '_ \| |\/| |/ _ \ __/ _` | |\r
   7 // | |_| | |_) | |  | |  __/ || (_| | |\r
   8 // |____/|_.__/|_|  |_|\___|\__\__,_|_|\r
   9 //\r
  10 // Auto-generated from Northwind on [TIMESTAMP]\r
  11 // Please visit http://linq.to/db for more information\r
  12 \r
  13 #endregion\r
  14 \r
  15 using System;\r
  16 using System.Data;\r
  17 using System.Data.Linq.Mapping;\r
  18 using System.Diagnostics;\r
  19 using System.Reflection;\r
  20 #if MONO_STRICT\r
  21 using System.Data.Linq;\r
  22 #else   // MONO_STRICT\r
  23 using DbLinq.Data.Linq;\r
  24 using DbLinq.Vendor;\r
  25 #endif  // MONO_STRICT\r
  26 using System.ComponentModel;\r
  27 \r
  28 namespace nwind\r
  29 {\r
  30         public partial class Northwind : DataContext\r
  31         {\r
  32                 #region Extensibility Method Definitions\r
  33 \r
  34                 partial void OnCreated();\r
  35 \r
  36                 #endregion\r
  37 \r
  38                 public Northwind(string connectionString)\r
  39                         : base(connectionString)\r
  40                 {\r
  41                         OnCreated();\r
  42                 }\r
  43 \r
  44                 public Northwind(IDbConnection connection)\r
  45                 #if MONO_STRICT\r
  46                         : base(connection)\r
  47                 #else   // MONO_STRICT\r
  48                         : base(connection, new DbLinq.Sqlite.SqliteVendor())\r
  49                 #endif  // MONO_STRICT\r
  50                 {\r
  51                         OnCreated();\r
  52                 }\r
  53 \r
  54                 public Northwind(string connection, MappingSource mappingSource)\r
  55                         : base(connection, mappingSource)\r
  56                 {\r
  57                         OnCreated();\r
  58                 }\r
  59 \r
  60                 public Northwind(IDbConnection connection, MappingSource mappingSource)\r
  61                         : base(connection, mappingSource)\r
  62                 {\r
  63                         OnCreated();\r
  64                 }\r
  65 \r
  66                 #if !MONO_STRICT\r
  67                 public Northwind(IDbConnection connection, IVendor vendor)\r
  68                         : base(connection, vendor)\r
  69                 {\r
  70                         OnCreated();\r
  71                 }\r
  72                 #endif  // !MONO_STRICT\r
  73 \r
  74                 #if !MONO_STRICT\r
  75                 public Northwind(IDbConnection connection, MappingSource mappingSource, IVendor vendor)\r
  76                         : base(connection, mappingSource, vendor)\r
  77                 {\r
  78                         OnCreated();\r
  79                 }\r
  80                 #endif  // !MONO_STRICT\r
  81 \r
  82                 public Table<Category> Categories { get { return GetTable<Category>(); } }\r
  83                 public Table<Customer> Customers { get { return GetTable<Customer>(); } }\r
  84                 public Table<CustomerCustomerDemo> CustomerCustomerDemo { get { return GetTable<CustomerCustomerDemo>(); } }\r
  85                 public Table<CustomerDemographic> CustomerDemographics { get { return GetTable<CustomerDemographic>(); } }\r
  86                 public Table<Employee> Employees { get { return GetTable<Employee>(); } }\r
  87                 public Table<EmployeeTerritory> EmployeeTerritories { get { return GetTable<EmployeeTerritory>(); } }\r
  88                 public Table<Order> Orders { get { return GetTable<Order>(); } }\r
  89                 public Table<OrderDetail> OrderDetails { get { return GetTable<OrderDetail>(); } }\r
  90                 public Table<Product> Products { get { return GetTable<Product>(); } }\r
  91                 public Table<Region> Regions { get { return GetTable<Region>(); } }\r
  92                 public Table<Shipper> Shippers { get { return GetTable<Shipper>(); } }\r
  93                 public Table<Supplier> Suppliers { get { return GetTable<Supplier>(); } }\r
  94                 public Table<Territory> Territories { get { return GetTable<Territory>(); } }\r
  95 \r
  96         }\r
  97 \r
  98         [Table(Name = "main.Categories")]\r
  99         public partial class Category : INotifyPropertyChanging, INotifyPropertyChanged\r
 100         {\r
 101                 #region INotifyPropertyChanging handling\r
 102 \r
 103                 public event PropertyChangingEventHandler PropertyChanging;\r
 104 \r
 105                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
 106                 protected virtual void SendPropertyChanging()\r
 107                 {\r
 108                         if (PropertyChanging != null)\r
 109                         {\r
 110                                 PropertyChanging(this, emptyChangingEventArgs);\r
 111                         }\r
 112                 }\r
 113 \r
 114                 #endregion\r
 115 \r
 116                 #region INotifyPropertyChanged handling\r
 117 \r
 118                 public event PropertyChangedEventHandler PropertyChanged;\r
 119 \r
 120                 protected virtual void SendPropertyChanged(string propertyName)\r
 121                 {\r
 122                         if (PropertyChanged != null)\r
 123                         {\r
 124                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
 125                         }\r
 126                 }\r
 127 \r
 128                 #endregion\r
 129 \r
 130                 #region Extensibility Method Definitions\r
 131 \r
 132                 partial void OnCreated();\r
 133                 partial void OnCategoryIDChanged();\r
 134                 partial void OnCategoryIDChanging(int value);\r
 135                 partial void OnCategoryNameChanged();\r
 136                 partial void OnCategoryNameChanging(string value);\r
 137                 partial void OnDescriptionChanged();\r
 138                 partial void OnDescriptionChanging(string value);\r
 139                 partial void OnPictureChanged();\r
 140                 partial void OnPictureChanging(Byte[] value);\r
 141 \r
 142                 #endregion\r
 143 \r
 144                 #region int CategoryID\r
 145 \r
 146                 private int _categoryID;\r
 147                 [DebuggerNonUserCode]\r
 148                 [Column(Storage = "_categoryID", Name = "CategoryID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
 149                 public int CategoryID\r
 150                 {\r
 151                         get\r
 152                         {\r
 153                                 return _categoryID;\r
 154                         }\r
 155                         set\r
 156                         {\r
 157                                 if (value != _categoryID)\r
 158                                 {\r
 159                                         OnCategoryIDChanging(value);\r
 160                                         SendPropertyChanging();\r
 161                                         _categoryID = value;\r
 162                                         SendPropertyChanged("CategoryID");\r
 163                                         OnCategoryIDChanged();\r
 164                                 }\r
 165                         }\r
 166                 }\r
 167 \r
 168                 #endregion\r
 169 \r
 170                 #region string CategoryName\r
 171 \r
 172                 private string _categoryName;\r
 173                 [DebuggerNonUserCode]\r
 174                 [Column(Storage = "_categoryName", Name = "CategoryName", DbType = "nvarchar (15)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
 175                 public string CategoryName\r
 176                 {\r
 177                         get\r
 178                         {\r
 179                                 return _categoryName;\r
 180                         }\r
 181                         set\r
 182                         {\r
 183                                 if (value != _categoryName)\r
 184                                 {\r
 185                                         OnCategoryNameChanging(value);\r
 186                                         SendPropertyChanging();\r
 187                                         _categoryName = value;\r
 188                                         SendPropertyChanged("CategoryName");\r
 189                                         OnCategoryNameChanged();\r
 190                                 }\r
 191                         }\r
 192                 }\r
 193 \r
 194                 #endregion\r
 195 \r
 196                 #region string Description\r
 197 \r
 198                 private string _description;\r
 199                 [DebuggerNonUserCode]\r
 200                 [Column(Storage = "_description", Name = "Description", DbType = "ntext", AutoSync = AutoSync.Never)]\r
 201                 public string Description\r
 202                 {\r
 203                         get\r
 204                         {\r
 205                                 return _description;\r
 206                         }\r
 207                         set\r
 208                         {\r
 209                                 if (value != _description)\r
 210                                 {\r
 211                                         OnDescriptionChanging(value);\r
 212                                         SendPropertyChanging();\r
 213                                         _description = value;\r
 214                                         SendPropertyChanged("Description");\r
 215                                         OnDescriptionChanged();\r
 216                                 }\r
 217                         }\r
 218                 }\r
 219 \r
 220                 #endregion\r
 221 \r
 222                 #region Byte[] Picture\r
 223 \r
 224                 private Byte[] _picture;\r
 225                 [DebuggerNonUserCode]\r
 226                 [Column(Storage = "_picture", Name = "Picture", DbType = "image", AutoSync = AutoSync.Never)]\r
 227                 public Byte[] Picture\r
 228                 {\r
 229                         get\r
 230                         {\r
 231                                 return _picture;\r
 232                         }\r
 233                         set\r
 234                         {\r
 235                                 if (value != _picture)\r
 236                                 {\r
 237                                         OnPictureChanging(value);\r
 238                                         SendPropertyChanging();\r
 239                                         _picture = value;\r
 240                                         SendPropertyChanged("Picture");\r
 241                                         OnPictureChanged();\r
 242                                 }\r
 243                         }\r
 244                 }\r
 245 \r
 246                 #endregion\r
 247 \r
 248                 #region Children\r
 249 \r
 250                 private EntitySet<Product> _products;\r
 251                 [Association(Storage = "_products", OtherKey = "CategoryID", ThisKey = "CategoryID", Name = "fk_Products_1")]\r
 252                 [DebuggerNonUserCode]\r
 253                 public EntitySet<Product> Products\r
 254                 {\r
 255                         get\r
 256                         {\r
 257                                 return _products;\r
 258                         }\r
 259                         set\r
 260                         {\r
 261                                 _products = value;\r
 262                         }\r
 263                 }\r
 264 \r
 265 \r
 266                 #endregion\r
 267 \r
 268                 #region Attachement handlers\r
 269 \r
 270                 private void Products_Attach(Product entity)\r
 271                 {\r
 272                         entity.Category = this;\r
 273                 }\r
 274 \r
 275                 private void Products_Detach(Product entity)\r
 276                 {\r
 277                         entity.Category = null;\r
 278                 }\r
 279 \r
 280 \r
 281                 #endregion\r
 282 \r
 283                 #region ctor\r
 284 \r
 285                 public Category()\r
 286                 {\r
 287                         _products = new EntitySet<Product>(Products_Attach, Products_Detach);\r
 288                         OnCreated();\r
 289                 }\r
 290 \r
 291                 #endregion\r
 292 \r
 293         }\r
 294 \r
 295         [Table(Name = "main.Customers")]\r
 296         public partial class Customer : INotifyPropertyChanging, INotifyPropertyChanged\r
 297         {\r
 298                 #region INotifyPropertyChanging handling\r
 299 \r
 300                 public event PropertyChangingEventHandler PropertyChanging;\r
 301 \r
 302                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
 303                 protected virtual void SendPropertyChanging()\r
 304                 {\r
 305                         if (PropertyChanging != null)\r
 306                         {\r
 307                                 PropertyChanging(this, emptyChangingEventArgs);\r
 308                         }\r
 309                 }\r
 310 \r
 311                 #endregion\r
 312 \r
 313                 #region INotifyPropertyChanged handling\r
 314 \r
 315                 public event PropertyChangedEventHandler PropertyChanged;\r
 316 \r
 317                 protected virtual void SendPropertyChanged(string propertyName)\r
 318                 {\r
 319                         if (PropertyChanged != null)\r
 320                         {\r
 321                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
 322                         }\r
 323                 }\r
 324 \r
 325                 #endregion\r
 326 \r
 327                 #region Extensibility Method Definitions\r
 328 \r
 329                 partial void OnCreated();\r
 330                 partial void OnAddressChanged();\r
 331                 partial void OnAddressChanging(string value);\r
 332                 partial void OnCityChanged();\r
 333                 partial void OnCityChanging(string value);\r
 334                 partial void OnCompanyNameChanged();\r
 335                 partial void OnCompanyNameChanging(string value);\r
 336                 partial void OnContactNameChanged();\r
 337                 partial void OnContactNameChanging(string value);\r
 338                 partial void OnContactTitleChanged();\r
 339                 partial void OnContactTitleChanging(string value);\r
 340                 partial void OnCountryChanged();\r
 341                 partial void OnCountryChanging(string value);\r
 342                 partial void OnCustomerIDChanged();\r
 343                 partial void OnCustomerIDChanging(string value);\r
 344                 partial void OnFaxChanged();\r
 345                 partial void OnFaxChanging(string value);\r
 346                 partial void OnPhoneChanged();\r
 347                 partial void OnPhoneChanging(string value);\r
 348                 partial void OnPostalCodeChanged();\r
 349                 partial void OnPostalCodeChanging(string value);\r
 350                 partial void OnRegionChanged();\r
 351                 partial void OnRegionChanging(string value);\r
 352 \r
 353                 #endregion\r
 354 \r
 355                 #region string Address\r
 356 \r
 357                 private string _address;\r
 358                 [DebuggerNonUserCode]\r
 359                 [Column(Storage = "_address", Name = "Address", DbType = "nvarchar (60)", AutoSync = AutoSync.Never)]\r
 360                 public string Address\r
 361                 {\r
 362                         get\r
 363                         {\r
 364                                 return _address;\r
 365                         }\r
 366                         set\r
 367                         {\r
 368                                 if (value != _address)\r
 369                                 {\r
 370                                         OnAddressChanging(value);\r
 371                                         SendPropertyChanging();\r
 372                                         _address = value;\r
 373                                         SendPropertyChanged("Address");\r
 374                                         OnAddressChanged();\r
 375                                 }\r
 376                         }\r
 377                 }\r
 378 \r
 379                 #endregion\r
 380 \r
 381                 #region string City\r
 382 \r
 383                 private string _city;\r
 384                 [DebuggerNonUserCode]\r
 385                 [Column(Storage = "_city", Name = "City", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
 386                 public string City\r
 387                 {\r
 388                         get\r
 389                         {\r
 390                                 return _city;\r
 391                         }\r
 392                         set\r
 393                         {\r
 394                                 if (value != _city)\r
 395                                 {\r
 396                                         OnCityChanging(value);\r
 397                                         SendPropertyChanging();\r
 398                                         _city = value;\r
 399                                         SendPropertyChanged("City");\r
 400                                         OnCityChanged();\r
 401                                 }\r
 402                         }\r
 403                 }\r
 404 \r
 405                 #endregion\r
 406 \r
 407                 #region string CompanyName\r
 408 \r
 409                 private string _companyName;\r
 410                 [DebuggerNonUserCode]\r
 411                 [Column(Storage = "_companyName", Name = "CompanyName", DbType = "nvarchar (40)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
 412                 public string CompanyName\r
 413                 {\r
 414                         get\r
 415                         {\r
 416                                 return _companyName;\r
 417                         }\r
 418                         set\r
 419                         {\r
 420                                 if (value != _companyName)\r
 421                                 {\r
 422                                         OnCompanyNameChanging(value);\r
 423                                         SendPropertyChanging();\r
 424                                         _companyName = value;\r
 425                                         SendPropertyChanged("CompanyName");\r
 426                                         OnCompanyNameChanged();\r
 427                                 }\r
 428                         }\r
 429                 }\r
 430 \r
 431                 #endregion\r
 432 \r
 433                 #region string ContactName\r
 434 \r
 435                 private string _contactName;\r
 436                 [DebuggerNonUserCode]\r
 437                 [Column(Storage = "_contactName", Name = "ContactName", DbType = "nvarchar (30)", AutoSync = AutoSync.Never)]\r
 438                 public string ContactName\r
 439                 {\r
 440                         get\r
 441                         {\r
 442                                 return _contactName;\r
 443                         }\r
 444                         set\r
 445                         {\r
 446                                 if (value != _contactName)\r
 447                                 {\r
 448                                         OnContactNameChanging(value);\r
 449                                         SendPropertyChanging();\r
 450                                         _contactName = value;\r
 451                                         SendPropertyChanged("ContactName");\r
 452                                         OnContactNameChanged();\r
 453                                 }\r
 454                         }\r
 455                 }\r
 456 \r
 457                 #endregion\r
 458 \r
 459                 #region string ContactTitle\r
 460 \r
 461                 private string _contactTitle;\r
 462                 [DebuggerNonUserCode]\r
 463                 [Column(Storage = "_contactTitle", Name = "ContactTitle", DbType = "nvarchar (30)", AutoSync = AutoSync.Never)]\r
 464                 public string ContactTitle\r
 465                 {\r
 466                         get\r
 467                         {\r
 468                                 return _contactTitle;\r
 469                         }\r
 470                         set\r
 471                         {\r
 472                                 if (value != _contactTitle)\r
 473                                 {\r
 474                                         OnContactTitleChanging(value);\r
 475                                         SendPropertyChanging();\r
 476                                         _contactTitle = value;\r
 477                                         SendPropertyChanged("ContactTitle");\r
 478                                         OnContactTitleChanged();\r
 479                                 }\r
 480                         }\r
 481                 }\r
 482 \r
 483                 #endregion\r
 484 \r
 485                 #region string Country\r
 486 \r
 487                 private string _country;\r
 488                 [DebuggerNonUserCode]\r
 489                 [Column(Storage = "_country", Name = "Country", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
 490                 public string Country\r
 491                 {\r
 492                         get\r
 493                         {\r
 494                                 return _country;\r
 495                         }\r
 496                         set\r
 497                         {\r
 498                                 if (value != _country)\r
 499                                 {\r
 500                                         OnCountryChanging(value);\r
 501                                         SendPropertyChanging();\r
 502                                         _country = value;\r
 503                                         SendPropertyChanged("Country");\r
 504                                         OnCountryChanged();\r
 505                                 }\r
 506                         }\r
 507                 }\r
 508 \r
 509                 #endregion\r
 510 \r
 511                 #region string CustomerID\r
 512 \r
 513                 private string _customerID;\r
 514                 [DebuggerNonUserCode]\r
 515                 [Column(Storage = "_customerID", Name = "CustomerID", DbType = "nchar (5)", IsPrimaryKey = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
 516                 public string CustomerID\r
 517                 {\r
 518                         get\r
 519                         {\r
 520                                 return _customerID;\r
 521                         }\r
 522                         set\r
 523                         {\r
 524                                 if (value != _customerID)\r
 525                                 {\r
 526                                         OnCustomerIDChanging(value);\r
 527                                         SendPropertyChanging();\r
 528                                         _customerID = value;\r
 529                                         SendPropertyChanged("CustomerID");\r
 530                                         OnCustomerIDChanged();\r
 531                                 }\r
 532                         }\r
 533                 }\r
 534 \r
 535                 #endregion\r
 536 \r
 537                 #region string Fax\r
 538 \r
 539                 private string _fax;\r
 540                 [DebuggerNonUserCode]\r
 541                 [Column(Storage = "_fax", Name = "Fax", DbType = "nvarchar (24)", AutoSync = AutoSync.Never)]\r
 542                 public string Fax\r
 543                 {\r
 544                         get\r
 545                         {\r
 546                                 return _fax;\r
 547                         }\r
 548                         set\r
 549                         {\r
 550                                 if (value != _fax)\r
 551                                 {\r
 552                                         OnFaxChanging(value);\r
 553                                         SendPropertyChanging();\r
 554                                         _fax = value;\r
 555                                         SendPropertyChanged("Fax");\r
 556                                         OnFaxChanged();\r
 557                                 }\r
 558                         }\r
 559                 }\r
 560 \r
 561                 #endregion\r
 562 \r
 563                 #region string Phone\r
 564 \r
 565                 private string _phone;\r
 566                 [DebuggerNonUserCode]\r
 567                 [Column(Storage = "_phone", Name = "Phone", DbType = "nvarchar (24)", AutoSync = AutoSync.Never)]\r
 568                 public string Phone\r
 569                 {\r
 570                         get\r
 571                         {\r
 572                                 return _phone;\r
 573                         }\r
 574                         set\r
 575                         {\r
 576                                 if (value != _phone)\r
 577                                 {\r
 578                                         OnPhoneChanging(value);\r
 579                                         SendPropertyChanging();\r
 580                                         _phone = value;\r
 581                                         SendPropertyChanged("Phone");\r
 582                                         OnPhoneChanged();\r
 583                                 }\r
 584                         }\r
 585                 }\r
 586 \r
 587                 #endregion\r
 588 \r
 589                 #region string PostalCode\r
 590 \r
 591                 private string _postalCode;\r
 592                 [DebuggerNonUserCode]\r
 593                 [Column(Storage = "_postalCode", Name = "PostalCode", DbType = "nvarchar (10)", AutoSync = AutoSync.Never)]\r
 594                 public string PostalCode\r
 595                 {\r
 596                         get\r
 597                         {\r
 598                                 return _postalCode;\r
 599                         }\r
 600                         set\r
 601                         {\r
 602                                 if (value != _postalCode)\r
 603                                 {\r
 604                                         OnPostalCodeChanging(value);\r
 605                                         SendPropertyChanging();\r
 606                                         _postalCode = value;\r
 607                                         SendPropertyChanged("PostalCode");\r
 608                                         OnPostalCodeChanged();\r
 609                                 }\r
 610                         }\r
 611                 }\r
 612 \r
 613                 #endregion\r
 614 \r
 615                 #region string Region\r
 616 \r
 617                 private string _region;\r
 618                 [DebuggerNonUserCode]\r
 619                 [Column(Storage = "_region", Name = "Region", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
 620                 public string Region\r
 621                 {\r
 622                         get\r
 623                         {\r
 624                                 return _region;\r
 625                         }\r
 626                         set\r
 627                         {\r
 628                                 if (value != _region)\r
 629                                 {\r
 630                                         OnRegionChanging(value);\r
 631                                         SendPropertyChanging();\r
 632                                         _region = value;\r
 633                                         SendPropertyChanged("Region");\r
 634                                         OnRegionChanged();\r
 635                                 }\r
 636                         }\r
 637                 }\r
 638 \r
 639                 #endregion\r
 640 \r
 641                 #region Children\r
 642 \r
 643                 private EntitySet<CustomerCustomerDemo> _customerCustomerDemo;\r
 644                 [Association(Storage = "_customerCustomerDemo", OtherKey = "CustomerID", ThisKey = "CustomerID", Name = "fk_CustomerCustomerDemo_0")]\r
 645                 [DebuggerNonUserCode]\r
 646                 public EntitySet<CustomerCustomerDemo> CustomerCustomerDemo\r
 647                 {\r
 648                         get\r
 649                         {\r
 650                                 return _customerCustomerDemo;\r
 651                         }\r
 652                         set\r
 653                         {\r
 654                                 _customerCustomerDemo = value;\r
 655                         }\r
 656                 }\r
 657 \r
 658                 private EntitySet<Order> _orders;\r
 659                 [Association(Storage = "_orders", OtherKey = "CustomerID", ThisKey = "CustomerID", Name = "fk_Orders_2")]\r
 660                 [DebuggerNonUserCode]\r
 661                 public EntitySet<Order> Orders\r
 662                 {\r
 663                         get\r
 664                         {\r
 665                                 return _orders;\r
 666                         }\r
 667                         set\r
 668                         {\r
 669                                 _orders = value;\r
 670                         }\r
 671                 }\r
 672 \r
 673 \r
 674                 #endregion\r
 675 \r
 676                 #region Attachement handlers\r
 677 \r
 678                 private void CustomerCustomerDemo_Attach(CustomerCustomerDemo entity)\r
 679                 {\r
 680                         entity.Customer = this;\r
 681                 }\r
 682 \r
 683                 private void CustomerCustomerDemo_Detach(CustomerCustomerDemo entity)\r
 684                 {\r
 685                         entity.Customer = null;\r
 686                 }\r
 687 \r
 688                 private void Orders_Attach(Order entity)\r
 689                 {\r
 690                         entity.Customer = this;\r
 691                 }\r
 692 \r
 693                 private void Orders_Detach(Order entity)\r
 694                 {\r
 695                         entity.Customer = null;\r
 696                 }\r
 697 \r
 698 \r
 699                 #endregion\r
 700 \r
 701                 #region ctor\r
 702 \r
 703                 public Customer()\r
 704                 {\r
 705                         _customerCustomerDemo = new EntitySet<CustomerCustomerDemo>(CustomerCustomerDemo_Attach, CustomerCustomerDemo_Detach);\r
 706                         _orders = new EntitySet<Order>(Orders_Attach, Orders_Detach);\r
 707                         OnCreated();\r
 708                 }\r
 709 \r
 710                 #endregion\r
 711 \r
 712         }\r
 713 \r
 714         [Table(Name = "main.CustomerCustomerDemo")]\r
 715         public partial class CustomerCustomerDemo : INotifyPropertyChanging, INotifyPropertyChanged\r
 716         {\r
 717                 #region INotifyPropertyChanging handling\r
 718 \r
 719                 public event PropertyChangingEventHandler PropertyChanging;\r
 720 \r
 721                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
 722                 protected virtual void SendPropertyChanging()\r
 723                 {\r
 724                         if (PropertyChanging != null)\r
 725                         {\r
 726                                 PropertyChanging(this, emptyChangingEventArgs);\r
 727                         }\r
 728                 }\r
 729 \r
 730                 #endregion\r
 731 \r
 732                 #region INotifyPropertyChanged handling\r
 733 \r
 734                 public event PropertyChangedEventHandler PropertyChanged;\r
 735 \r
 736                 protected virtual void SendPropertyChanged(string propertyName)\r
 737                 {\r
 738                         if (PropertyChanged != null)\r
 739                         {\r
 740                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
 741                         }\r
 742                 }\r
 743 \r
 744                 #endregion\r
 745 \r
 746                 #region Extensibility Method Definitions\r
 747 \r
 748                 partial void OnCreated();\r
 749                 partial void OnCustomerIDChanged();\r
 750                 partial void OnCustomerIDChanging(string value);\r
 751                 partial void OnCustomerTypeIDChanged();\r
 752                 partial void OnCustomerTypeIDChanging(string value);\r
 753 \r
 754                 #endregion\r
 755 \r
 756                 #region string CustomerID\r
 757 \r
 758                 private string _customerID;\r
 759                 [DebuggerNonUserCode]\r
 760                 [Column(Storage = "_customerID", Name = "CustomerID", DbType = "nchar (5)", IsPrimaryKey = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
 761                 public string CustomerID\r
 762                 {\r
 763                         get\r
 764                         {\r
 765                                 return _customerID;\r
 766                         }\r
 767                         set\r
 768                         {\r
 769                                 if (value != _customerID)\r
 770                                 {\r
 771                                         if (_customer.HasLoadedOrAssignedValue)\r
 772                                         {\r
 773                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
 774                                         }\r
 775                                         OnCustomerIDChanging(value);\r
 776                                         SendPropertyChanging();\r
 777                                         _customerID = value;\r
 778                                         SendPropertyChanged("CustomerID");\r
 779                                         OnCustomerIDChanged();\r
 780                                 }\r
 781                         }\r
 782                 }\r
 783 \r
 784                 #endregion\r
 785 \r
 786                 #region string CustomerTypeID\r
 787 \r
 788                 private string _customerTypeID;\r
 789                 [DebuggerNonUserCode]\r
 790                 [Column(Storage = "_customerTypeID", Name = "CustomerTypeID", DbType = "nchar", IsPrimaryKey = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
 791                 public string CustomerTypeID\r
 792                 {\r
 793                         get\r
 794                         {\r
 795                                 return _customerTypeID;\r
 796                         }\r
 797                         set\r
 798                         {\r
 799                                 if (value != _customerTypeID)\r
 800                                 {\r
 801                                         if (_customerDemographic.HasLoadedOrAssignedValue)\r
 802                                         {\r
 803                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
 804                                         }\r
 805                                         OnCustomerTypeIDChanging(value);\r
 806                                         SendPropertyChanging();\r
 807                                         _customerTypeID = value;\r
 808                                         SendPropertyChanged("CustomerTypeID");\r
 809                                         OnCustomerTypeIDChanged();\r
 810                                 }\r
 811                         }\r
 812                 }\r
 813 \r
 814                 #endregion\r
 815 \r
 816                 #region Parents\r
 817 \r
 818                 private EntityRef<Customer> _customer;\r
 819                 [Association(Storage = "_customer", OtherKey = "CustomerID", ThisKey = "CustomerID", Name = "fk_CustomerCustomerDemo_0", IsForeignKey = true)]\r
 820                 [DebuggerNonUserCode]\r
 821                 public Customer Customer\r
 822                 {\r
 823                         get\r
 824                         {\r
 825                                 return _customer.Entity;\r
 826                         }\r
 827                         set\r
 828                         {\r
 829                                 if (value != _customer.Entity)\r
 830                                 {\r
 831                                         if (_customer.Entity != null)\r
 832                                         {\r
 833                                                 var previousCustomer = _customer.Entity;\r
 834                                                 _customer.Entity = null;\r
 835                                                 previousCustomer.CustomerCustomerDemo.Remove(this);\r
 836                                         }\r
 837                                         _customer.Entity = value;\r
 838                                         if (value != null)\r
 839                                         {\r
 840                                                 value.CustomerCustomerDemo.Add(this);\r
 841                                                 _customerID = value.CustomerID;\r
 842                                         }\r
 843                                         else\r
 844                                         {\r
 845                                                 _customerID = default(string);\r
 846                                         }\r
 847                                 }\r
 848                         }\r
 849                 }\r
 850 \r
 851                 private EntityRef<CustomerDemographic> _customerDemographic;\r
 852                 [Association(Storage = "_customerDemographic", OtherKey = "CustomerTypeID", ThisKey = "CustomerTypeID", Name = "fk_CustomerCustomerDemo_1", IsForeignKey = true)]\r
 853                 [DebuggerNonUserCode]\r
 854                 public CustomerDemographic CustomerDemographic\r
 855                 {\r
 856                         get\r
 857                         {\r
 858                                 return _customerDemographic.Entity;\r
 859                         }\r
 860                         set\r
 861                         {\r
 862                                 if (value != _customerDemographic.Entity)\r
 863                                 {\r
 864                                         if (_customerDemographic.Entity != null)\r
 865                                         {\r
 866                                                 var previousCustomerDemographic = _customerDemographic.Entity;\r
 867                                                 _customerDemographic.Entity = null;\r
 868                                                 previousCustomerDemographic.CustomerCustomerDemo.Remove(this);\r
 869                                         }\r
 870                                         _customerDemographic.Entity = value;\r
 871                                         if (value != null)\r
 872                                         {\r
 873                                                 value.CustomerCustomerDemo.Add(this);\r
 874                                                 _customerTypeID = value.CustomerTypeID;\r
 875                                         }\r
 876                                         else\r
 877                                         {\r
 878                                                 _customerTypeID = default(string);\r
 879                                         }\r
 880                                 }\r
 881                         }\r
 882                 }\r
 883 \r
 884 \r
 885                 #endregion\r
 886 \r
 887                 #region ctor\r
 888 \r
 889                 public CustomerCustomerDemo()\r
 890                 {\r
 891                         _customer = new EntityRef<Customer>();\r
 892                         _customerDemographic = new EntityRef<CustomerDemographic>();\r
 893                         OnCreated();\r
 894                 }\r
 895 \r
 896                 #endregion\r
 897 \r
 898         }\r
 899 \r
 900         [Table(Name = "main.CustomerDemographics")]\r
 901         public partial class CustomerDemographic : INotifyPropertyChanging, INotifyPropertyChanged\r
 902         {\r
 903                 #region INotifyPropertyChanging handling\r
 904 \r
 905                 public event PropertyChangingEventHandler PropertyChanging;\r
 906 \r
 907                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
 908                 protected virtual void SendPropertyChanging()\r
 909                 {\r
 910                         if (PropertyChanging != null)\r
 911                         {\r
 912                                 PropertyChanging(this, emptyChangingEventArgs);\r
 913                         }\r
 914                 }\r
 915 \r
 916                 #endregion\r
 917 \r
 918                 #region INotifyPropertyChanged handling\r
 919 \r
 920                 public event PropertyChangedEventHandler PropertyChanged;\r
 921 \r
 922                 protected virtual void SendPropertyChanged(string propertyName)\r
 923                 {\r
 924                         if (PropertyChanged != null)\r
 925                         {\r
 926                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
 927                         }\r
 928                 }\r
 929 \r
 930                 #endregion\r
 931 \r
 932                 #region Extensibility Method Definitions\r
 933 \r
 934                 partial void OnCreated();\r
 935                 partial void OnCustomerDescChanged();\r
 936                 partial void OnCustomerDescChanging(string value);\r
 937                 partial void OnCustomerTypeIDChanged();\r
 938                 partial void OnCustomerTypeIDChanging(string value);\r
 939 \r
 940                 #endregion\r
 941 \r
 942                 #region string CustomerDesc\r
 943 \r
 944                 private string _customerDesc;\r
 945                 [DebuggerNonUserCode]\r
 946                 [Column(Storage = "_customerDesc", Name = "CustomerDesc", DbType = "ntext", AutoSync = AutoSync.Never)]\r
 947                 public string CustomerDesc\r
 948                 {\r
 949                         get\r
 950                         {\r
 951                                 return _customerDesc;\r
 952                         }\r
 953                         set\r
 954                         {\r
 955                                 if (value != _customerDesc)\r
 956                                 {\r
 957                                         OnCustomerDescChanging(value);\r
 958                                         SendPropertyChanging();\r
 959                                         _customerDesc = value;\r
 960                                         SendPropertyChanged("CustomerDesc");\r
 961                                         OnCustomerDescChanged();\r
 962                                 }\r
 963                         }\r
 964                 }\r
 965 \r
 966                 #endregion\r
 967 \r
 968                 #region string CustomerTypeID\r
 969 \r
 970                 private string _customerTypeID;\r
 971                 [DebuggerNonUserCode]\r
 972                 [Column(Storage = "_customerTypeID", Name = "CustomerTypeID", DbType = "nchar", IsPrimaryKey = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
 973                 public string CustomerTypeID\r
 974                 {\r
 975                         get\r
 976                         {\r
 977                                 return _customerTypeID;\r
 978                         }\r
 979                         set\r
 980                         {\r
 981                                 if (value != _customerTypeID)\r
 982                                 {\r
 983                                         OnCustomerTypeIDChanging(value);\r
 984                                         SendPropertyChanging();\r
 985                                         _customerTypeID = value;\r
 986                                         SendPropertyChanged("CustomerTypeID");\r
 987                                         OnCustomerTypeIDChanged();\r
 988                                 }\r
 989                         }\r
 990                 }\r
 991 \r
 992                 #endregion\r
 993 \r
 994                 #region Children\r
 995 \r
 996                 private EntitySet<CustomerCustomerDemo> _customerCustomerDemo;\r
 997                 [Association(Storage = "_customerCustomerDemo", OtherKey = "CustomerTypeID", ThisKey = "CustomerTypeID", Name = "fk_CustomerCustomerDemo_1")]\r
 998                 [DebuggerNonUserCode]\r
 999                 public EntitySet<CustomerCustomerDemo> CustomerCustomerDemo\r
1000                 {\r
1001                         get\r
1002                         {\r
1003                                 return _customerCustomerDemo;\r
1004                         }\r
1005                         set\r
1006                         {\r
1007                                 _customerCustomerDemo = value;\r
1008                         }\r
1009                 }\r
1010 \r
1011 \r
1012                 #endregion\r
1013 \r
1014                 #region Attachement handlers\r
1015 \r
1016                 private void CustomerCustomerDemo_Attach(CustomerCustomerDemo entity)\r
1017                 {\r
1018                         entity.CustomerDemographic = this;\r
1019                 }\r
1020 \r
1021                 private void CustomerCustomerDemo_Detach(CustomerCustomerDemo entity)\r
1022                 {\r
1023                         entity.CustomerDemographic = null;\r
1024                 }\r
1025 \r
1026 \r
1027                 #endregion\r
1028 \r
1029                 #region ctor\r
1030 \r
1031                 public CustomerDemographic()\r
1032                 {\r
1033                         _customerCustomerDemo = new EntitySet<CustomerCustomerDemo>(CustomerCustomerDemo_Attach, CustomerCustomerDemo_Detach);\r
1034                         OnCreated();\r
1035                 }\r
1036 \r
1037                 #endregion\r
1038 \r
1039         }\r
1040 \r
1041         [Table(Name = "main.Employees")]\r
1042         public partial class Employee : INotifyPropertyChanging, INotifyPropertyChanged\r
1043         {\r
1044                 #region INotifyPropertyChanging handling\r
1045 \r
1046                 public event PropertyChangingEventHandler PropertyChanging;\r
1047 \r
1048                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
1049                 protected virtual void SendPropertyChanging()\r
1050                 {\r
1051                         if (PropertyChanging != null)\r
1052                         {\r
1053                                 PropertyChanging(this, emptyChangingEventArgs);\r
1054                         }\r
1055                 }\r
1056 \r
1057                 #endregion\r
1058 \r
1059                 #region INotifyPropertyChanged handling\r
1060 \r
1061                 public event PropertyChangedEventHandler PropertyChanged;\r
1062 \r
1063                 protected virtual void SendPropertyChanged(string propertyName)\r
1064                 {\r
1065                         if (PropertyChanged != null)\r
1066                         {\r
1067                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
1068                         }\r
1069                 }\r
1070 \r
1071                 #endregion\r
1072 \r
1073                 #region Extensibility Method Definitions\r
1074 \r
1075                 partial void OnCreated();\r
1076                 partial void OnAddressChanged();\r
1077                 partial void OnAddressChanging(string value);\r
1078                 partial void OnBirthDateChanged();\r
1079                 partial void OnBirthDateChanging(DateTime? value);\r
1080                 partial void OnCityChanged();\r
1081                 partial void OnCityChanging(string value);\r
1082                 partial void OnCountryChanged();\r
1083                 partial void OnCountryChanging(string value);\r
1084                 partial void OnEmployeeIDChanged();\r
1085                 partial void OnEmployeeIDChanging(int value);\r
1086                 partial void OnExtensionChanged();\r
1087                 partial void OnExtensionChanging(string value);\r
1088                 partial void OnFirstNameChanged();\r
1089                 partial void OnFirstNameChanging(string value);\r
1090                 partial void OnHireDateChanged();\r
1091                 partial void OnHireDateChanging(DateTime? value);\r
1092                 partial void OnHomePhoneChanged();\r
1093                 partial void OnHomePhoneChanging(string value);\r
1094                 partial void OnLastNameChanged();\r
1095                 partial void OnLastNameChanging(string value);\r
1096                 partial void OnNotesChanged();\r
1097                 partial void OnNotesChanging(string value);\r
1098                 partial void OnPhotoChanged();\r
1099                 partial void OnPhotoChanging(Byte[] value);\r
1100                 partial void OnPhotoPathChanged();\r
1101                 partial void OnPhotoPathChanging(string value);\r
1102                 partial void OnPostalCodeChanged();\r
1103                 partial void OnPostalCodeChanging(string value);\r
1104                 partial void OnRegionChanged();\r
1105                 partial void OnRegionChanging(string value);\r
1106                 partial void OnReportsToChanged();\r
1107                 partial void OnReportsToChanging(int? value);\r
1108                 partial void OnTitleChanged();\r
1109                 partial void OnTitleChanging(string value);\r
1110                 partial void OnTitleOfCourtesyChanged();\r
1111                 partial void OnTitleOfCourtesyChanging(string value);\r
1112 \r
1113                 #endregion\r
1114 \r
1115                 #region string Address\r
1116 \r
1117                 private string _address;\r
1118                 [DebuggerNonUserCode]\r
1119                 [Column(Storage = "_address", Name = "Address", DbType = "nvarchar (60)", AutoSync = AutoSync.Never)]\r
1120                 public string Address\r
1121                 {\r
1122                         get\r
1123                         {\r
1124                                 return _address;\r
1125                         }\r
1126                         set\r
1127                         {\r
1128                                 if (value != _address)\r
1129                                 {\r
1130                                         OnAddressChanging(value);\r
1131                                         SendPropertyChanging();\r
1132                                         _address = value;\r
1133                                         SendPropertyChanged("Address");\r
1134                                         OnAddressChanged();\r
1135                                 }\r
1136                         }\r
1137                 }\r
1138 \r
1139                 #endregion\r
1140 \r
1141                 #region DateTime? BirthDate\r
1142 \r
1143                 private DateTime? _birthDate;\r
1144                 [DebuggerNonUserCode]\r
1145                 [Column(Storage = "_birthDate", Name = "BirthDate", DbType = "datetime", AutoSync = AutoSync.Never)]\r
1146                 public DateTime? BirthDate\r
1147                 {\r
1148                         get\r
1149                         {\r
1150                                 return _birthDate;\r
1151                         }\r
1152                         set\r
1153                         {\r
1154                                 if (value != _birthDate)\r
1155                                 {\r
1156                                         OnBirthDateChanging(value);\r
1157                                         SendPropertyChanging();\r
1158                                         _birthDate = value;\r
1159                                         SendPropertyChanged("BirthDate");\r
1160                                         OnBirthDateChanged();\r
1161                                 }\r
1162                         }\r
1163                 }\r
1164 \r
1165                 #endregion\r
1166 \r
1167                 #region string City\r
1168 \r
1169                 private string _city;\r
1170                 [DebuggerNonUserCode]\r
1171                 [Column(Storage = "_city", Name = "City", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
1172                 public string City\r
1173                 {\r
1174                         get\r
1175                         {\r
1176                                 return _city;\r
1177                         }\r
1178                         set\r
1179                         {\r
1180                                 if (value != _city)\r
1181                                 {\r
1182                                         OnCityChanging(value);\r
1183                                         SendPropertyChanging();\r
1184                                         _city = value;\r
1185                                         SendPropertyChanged("City");\r
1186                                         OnCityChanged();\r
1187                                 }\r
1188                         }\r
1189                 }\r
1190 \r
1191                 #endregion\r
1192 \r
1193                 #region string Country\r
1194 \r
1195                 private string _country;\r
1196                 [DebuggerNonUserCode]\r
1197                 [Column(Storage = "_country", Name = "Country", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
1198                 public string Country\r
1199                 {\r
1200                         get\r
1201                         {\r
1202                                 return _country;\r
1203                         }\r
1204                         set\r
1205                         {\r
1206                                 if (value != _country)\r
1207                                 {\r
1208                                         OnCountryChanging(value);\r
1209                                         SendPropertyChanging();\r
1210                                         _country = value;\r
1211                                         SendPropertyChanged("Country");\r
1212                                         OnCountryChanged();\r
1213                                 }\r
1214                         }\r
1215                 }\r
1216 \r
1217                 #endregion\r
1218 \r
1219                 #region int EmployeeID\r
1220 \r
1221                 private int _employeeID;\r
1222                 [DebuggerNonUserCode]\r
1223                 [Column(Storage = "_employeeID", Name = "EmployeeID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
1224                 public int EmployeeID\r
1225                 {\r
1226                         get\r
1227                         {\r
1228                                 return _employeeID;\r
1229                         }\r
1230                         set\r
1231                         {\r
1232                                 if (value != _employeeID)\r
1233                                 {\r
1234                                         OnEmployeeIDChanging(value);\r
1235                                         SendPropertyChanging();\r
1236                                         _employeeID = value;\r
1237                                         SendPropertyChanged("EmployeeID");\r
1238                                         OnEmployeeIDChanged();\r
1239                                 }\r
1240                         }\r
1241                 }\r
1242 \r
1243                 #endregion\r
1244 \r
1245                 #region string Extension\r
1246 \r
1247                 private string _extension;\r
1248                 [DebuggerNonUserCode]\r
1249                 [Column(Storage = "_extension", Name = "Extension", DbType = "nvarchar (4)", AutoSync = AutoSync.Never)]\r
1250                 public string Extension\r
1251                 {\r
1252                         get\r
1253                         {\r
1254                                 return _extension;\r
1255                         }\r
1256                         set\r
1257                         {\r
1258                                 if (value != _extension)\r
1259                                 {\r
1260                                         OnExtensionChanging(value);\r
1261                                         SendPropertyChanging();\r
1262                                         _extension = value;\r
1263                                         SendPropertyChanged("Extension");\r
1264                                         OnExtensionChanged();\r
1265                                 }\r
1266                         }\r
1267                 }\r
1268 \r
1269                 #endregion\r
1270 \r
1271                 #region string FirstName\r
1272 \r
1273                 private string _firstName;\r
1274                 [DebuggerNonUserCode]\r
1275                 [Column(Storage = "_firstName", Name = "FirstName", DbType = "nvarchar (10)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
1276                 public string FirstName\r
1277                 {\r
1278                         get\r
1279                         {\r
1280                                 return _firstName;\r
1281                         }\r
1282                         set\r
1283                         {\r
1284                                 if (value != _firstName)\r
1285                                 {\r
1286                                         OnFirstNameChanging(value);\r
1287                                         SendPropertyChanging();\r
1288                                         _firstName = value;\r
1289                                         SendPropertyChanged("FirstName");\r
1290                                         OnFirstNameChanged();\r
1291                                 }\r
1292                         }\r
1293                 }\r
1294 \r
1295                 #endregion\r
1296 \r
1297                 #region DateTime? HireDate\r
1298 \r
1299                 private DateTime? _hireDate;\r
1300                 [DebuggerNonUserCode]\r
1301                 [Column(Storage = "_hireDate", Name = "HireDate", DbType = "datetime", AutoSync = AutoSync.Never)]\r
1302                 public DateTime? HireDate\r
1303                 {\r
1304                         get\r
1305                         {\r
1306                                 return _hireDate;\r
1307                         }\r
1308                         set\r
1309                         {\r
1310                                 if (value != _hireDate)\r
1311                                 {\r
1312                                         OnHireDateChanging(value);\r
1313                                         SendPropertyChanging();\r
1314                                         _hireDate = value;\r
1315                                         SendPropertyChanged("HireDate");\r
1316                                         OnHireDateChanged();\r
1317                                 }\r
1318                         }\r
1319                 }\r
1320 \r
1321                 #endregion\r
1322 \r
1323                 #region string HomePhone\r
1324 \r
1325                 private string _homePhone;\r
1326                 [DebuggerNonUserCode]\r
1327                 [Column(Storage = "_homePhone", Name = "HomePhone", DbType = "nvarchar (24)", AutoSync = AutoSync.Never)]\r
1328                 public string HomePhone\r
1329                 {\r
1330                         get\r
1331                         {\r
1332                                 return _homePhone;\r
1333                         }\r
1334                         set\r
1335                         {\r
1336                                 if (value != _homePhone)\r
1337                                 {\r
1338                                         OnHomePhoneChanging(value);\r
1339                                         SendPropertyChanging();\r
1340                                         _homePhone = value;\r
1341                                         SendPropertyChanged("HomePhone");\r
1342                                         OnHomePhoneChanged();\r
1343                                 }\r
1344                         }\r
1345                 }\r
1346 \r
1347                 #endregion\r
1348 \r
1349                 #region string LastName\r
1350 \r
1351                 private string _lastName;\r
1352                 [DebuggerNonUserCode]\r
1353                 [Column(Storage = "_lastName", Name = "LastName", DbType = "nvarchar (20)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
1354                 public string LastName\r
1355                 {\r
1356                         get\r
1357                         {\r
1358                                 return _lastName;\r
1359                         }\r
1360                         set\r
1361                         {\r
1362                                 if (value != _lastName)\r
1363                                 {\r
1364                                         OnLastNameChanging(value);\r
1365                                         SendPropertyChanging();\r
1366                                         _lastName = value;\r
1367                                         SendPropertyChanged("LastName");\r
1368                                         OnLastNameChanged();\r
1369                                 }\r
1370                         }\r
1371                 }\r
1372 \r
1373                 #endregion\r
1374 \r
1375                 #region string Notes\r
1376 \r
1377                 private string _notes;\r
1378                 [DebuggerNonUserCode]\r
1379                 [Column(Storage = "_notes", Name = "Notes", DbType = "ntext", AutoSync = AutoSync.Never)]\r
1380                 public string Notes\r
1381                 {\r
1382                         get\r
1383                         {\r
1384                                 return _notes;\r
1385                         }\r
1386                         set\r
1387                         {\r
1388                                 if (value != _notes)\r
1389                                 {\r
1390                                         OnNotesChanging(value);\r
1391                                         SendPropertyChanging();\r
1392                                         _notes = value;\r
1393                                         SendPropertyChanged("Notes");\r
1394                                         OnNotesChanged();\r
1395                                 }\r
1396                         }\r
1397                 }\r
1398 \r
1399                 #endregion\r
1400 \r
1401                 #region Byte[] Photo\r
1402 \r
1403                 private Byte[] _photo;\r
1404                 [DebuggerNonUserCode]\r
1405                 [Column(Storage = "_photo", Name = "Photo", DbType = "image", AutoSync = AutoSync.Never)]\r
1406                 public Byte[] Photo\r
1407                 {\r
1408                         get\r
1409                         {\r
1410                                 return _photo;\r
1411                         }\r
1412                         set\r
1413                         {\r
1414                                 if (value != _photo)\r
1415                                 {\r
1416                                         OnPhotoChanging(value);\r
1417                                         SendPropertyChanging();\r
1418                                         _photo = value;\r
1419                                         SendPropertyChanged("Photo");\r
1420                                         OnPhotoChanged();\r
1421                                 }\r
1422                         }\r
1423                 }\r
1424 \r
1425                 #endregion\r
1426 \r
1427                 #region string PhotoPath\r
1428 \r
1429                 private string _photoPath;\r
1430                 [DebuggerNonUserCode]\r
1431                 [Column(Storage = "_photoPath", Name = "PhotoPath", DbType = "nvarchar (255)", AutoSync = AutoSync.Never)]\r
1432                 public string PhotoPath\r
1433                 {\r
1434                         get\r
1435                         {\r
1436                                 return _photoPath;\r
1437                         }\r
1438                         set\r
1439                         {\r
1440                                 if (value != _photoPath)\r
1441                                 {\r
1442                                         OnPhotoPathChanging(value);\r
1443                                         SendPropertyChanging();\r
1444                                         _photoPath = value;\r
1445                                         SendPropertyChanged("PhotoPath");\r
1446                                         OnPhotoPathChanged();\r
1447                                 }\r
1448                         }\r
1449                 }\r
1450 \r
1451                 #endregion\r
1452 \r
1453                 #region string PostalCode\r
1454 \r
1455                 private string _postalCode;\r
1456                 [DebuggerNonUserCode]\r
1457                 [Column(Storage = "_postalCode", Name = "PostalCode", DbType = "nvarchar (10)", AutoSync = AutoSync.Never)]\r
1458                 public string PostalCode\r
1459                 {\r
1460                         get\r
1461                         {\r
1462                                 return _postalCode;\r
1463                         }\r
1464                         set\r
1465                         {\r
1466                                 if (value != _postalCode)\r
1467                                 {\r
1468                                         OnPostalCodeChanging(value);\r
1469                                         SendPropertyChanging();\r
1470                                         _postalCode = value;\r
1471                                         SendPropertyChanged("PostalCode");\r
1472                                         OnPostalCodeChanged();\r
1473                                 }\r
1474                         }\r
1475                 }\r
1476 \r
1477                 #endregion\r
1478 \r
1479                 #region string Region\r
1480 \r
1481                 private string _region;\r
1482                 [DebuggerNonUserCode]\r
1483                 [Column(Storage = "_region", Name = "Region", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
1484                 public string Region\r
1485                 {\r
1486                         get\r
1487                         {\r
1488                                 return _region;\r
1489                         }\r
1490                         set\r
1491                         {\r
1492                                 if (value != _region)\r
1493                                 {\r
1494                                         OnRegionChanging(value);\r
1495                                         SendPropertyChanging();\r
1496                                         _region = value;\r
1497                                         SendPropertyChanged("Region");\r
1498                                         OnRegionChanged();\r
1499                                 }\r
1500                         }\r
1501                 }\r
1502 \r
1503                 #endregion\r
1504 \r
1505                 #region int? ReportsTo\r
1506 \r
1507                 private int? _reportsTo;\r
1508                 [DebuggerNonUserCode]\r
1509                 [Column(Storage = "_reportsTo", Name = "ReportsTo", DbType = "INTEGER", AutoSync = AutoSync.Never)]\r
1510                 public int? ReportsTo\r
1511                 {\r
1512                         get\r
1513                         {\r
1514                                 return _reportsTo;\r
1515                         }\r
1516                         set\r
1517                         {\r
1518                                 if (value != _reportsTo)\r
1519                                 {\r
1520                                         if (_reportsToEmployee.HasLoadedOrAssignedValue)\r
1521                                         {\r
1522                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
1523                                         }\r
1524                                         OnReportsToChanging(value);\r
1525                                         SendPropertyChanging();\r
1526                                         _reportsTo = value;\r
1527                                         SendPropertyChanged("ReportsTo");\r
1528                                         OnReportsToChanged();\r
1529                                 }\r
1530                         }\r
1531                 }\r
1532 \r
1533                 #endregion\r
1534 \r
1535                 #region string Title\r
1536 \r
1537                 private string _title;\r
1538                 [DebuggerNonUserCode]\r
1539                 [Column(Storage = "_title", Name = "Title", DbType = "nvarchar (30)", AutoSync = AutoSync.Never)]\r
1540                 public string Title\r
1541                 {\r
1542                         get\r
1543                         {\r
1544                                 return _title;\r
1545                         }\r
1546                         set\r
1547                         {\r
1548                                 if (value != _title)\r
1549                                 {\r
1550                                         OnTitleChanging(value);\r
1551                                         SendPropertyChanging();\r
1552                                         _title = value;\r
1553                                         SendPropertyChanged("Title");\r
1554                                         OnTitleChanged();\r
1555                                 }\r
1556                         }\r
1557                 }\r
1558 \r
1559                 #endregion\r
1560 \r
1561                 #region string TitleOfCourtesy\r
1562 \r
1563                 private string _titleOfCourtesy;\r
1564                 [DebuggerNonUserCode]\r
1565                 [Column(Storage = "_titleOfCourtesy", Name = "TitleOfCourtesy", DbType = "nvarchar (25)", AutoSync = AutoSync.Never)]\r
1566                 public string TitleOfCourtesy\r
1567                 {\r
1568                         get\r
1569                         {\r
1570                                 return _titleOfCourtesy;\r
1571                         }\r
1572                         set\r
1573                         {\r
1574                                 if (value != _titleOfCourtesy)\r
1575                                 {\r
1576                                         OnTitleOfCourtesyChanging(value);\r
1577                                         SendPropertyChanging();\r
1578                                         _titleOfCourtesy = value;\r
1579                                         SendPropertyChanged("TitleOfCourtesy");\r
1580                                         OnTitleOfCourtesyChanged();\r
1581                                 }\r
1582                         }\r
1583                 }\r
1584 \r
1585                 #endregion\r
1586 \r
1587                 #region Children\r
1588 \r
1589                 private EntitySet<EmployeeTerritory> _employeeTerritories;\r
1590                 [Association(Storage = "_employeeTerritories", OtherKey = "EmployeeID", ThisKey = "EmployeeID", Name = "fk_EmployeeTerritories_1")]\r
1591                 [DebuggerNonUserCode]\r
1592                 public EntitySet<EmployeeTerritory> EmployeeTerritories\r
1593                 {\r
1594                         get\r
1595                         {\r
1596                                 return _employeeTerritories;\r
1597                         }\r
1598                         set\r
1599                         {\r
1600                                 _employeeTerritories = value;\r
1601                         }\r
1602                 }\r
1603 \r
1604                 private EntitySet<Employee> _employees;\r
1605                 [Association(Storage = "_employees", OtherKey = "ReportsTo", ThisKey = "EmployeeID", Name = "fk_Employees_0")]\r
1606                 [DebuggerNonUserCode]\r
1607                 public EntitySet<Employee> Employees\r
1608                 {\r
1609                         get\r
1610                         {\r
1611                                 return _employees;\r
1612                         }\r
1613                         set\r
1614                         {\r
1615                                 _employees = value;\r
1616                         }\r
1617                 }\r
1618 \r
1619                 private EntitySet<Order> _orders;\r
1620                 [Association(Storage = "_orders", OtherKey = "EmployeeID", ThisKey = "EmployeeID", Name = "fk_Orders_1")]\r
1621                 [DebuggerNonUserCode]\r
1622                 public EntitySet<Order> Orders\r
1623                 {\r
1624                         get\r
1625                         {\r
1626                                 return _orders;\r
1627                         }\r
1628                         set\r
1629                         {\r
1630                                 _orders = value;\r
1631                         }\r
1632                 }\r
1633 \r
1634 \r
1635                 #endregion\r
1636 \r
1637                 #region Parents\r
1638 \r
1639                 private EntityRef<Employee> _reportsToEmployee;\r
1640                 [Association(Storage = "_reportsToEmployee", OtherKey = "EmployeeID", ThisKey = "ReportsTo", Name = "fk_Employees_0", IsForeignKey = true)]\r
1641                 [DebuggerNonUserCode]\r
1642                 public Employee ReportsToEmployee\r
1643                 {\r
1644                         get\r
1645                         {\r
1646                                 return _reportsToEmployee.Entity;\r
1647                         }\r
1648                         set\r
1649                         {\r
1650                                 if (value != _reportsToEmployee.Entity)\r
1651                                 {\r
1652                                         if (_reportsToEmployee.Entity != null)\r
1653                                         {\r
1654                                                 var previousEmployee = _reportsToEmployee.Entity;\r
1655                                                 _reportsToEmployee.Entity = null;\r
1656                                                 previousEmployee.Employees.Remove(this);\r
1657                                         }\r
1658                                         _reportsToEmployee.Entity = value;\r
1659                                         if (value != null)\r
1660                                         {\r
1661                                                 value.Employees.Add(this);\r
1662                                                 _reportsTo = value.EmployeeID;\r
1663                                         }\r
1664                                         else\r
1665                                         {\r
1666                                                 _reportsTo = null;\r
1667                                         }\r
1668                                 }\r
1669                         }\r
1670                 }\r
1671 \r
1672 \r
1673                 #endregion\r
1674 \r
1675                 #region Attachement handlers\r
1676 \r
1677                 private void EmployeeTerritories_Attach(EmployeeTerritory entity)\r
1678                 {\r
1679                         entity.Employee = this;\r
1680                 }\r
1681 \r
1682                 private void EmployeeTerritories_Detach(EmployeeTerritory entity)\r
1683                 {\r
1684                         entity.Employee = null;\r
1685                 }\r
1686 \r
1687                 private void Employees_Attach(Employee entity)\r
1688                 {\r
1689                         entity.ReportsToEmployee = this;\r
1690                 }\r
1691 \r
1692                 private void Employees_Detach(Employee entity)\r
1693                 {\r
1694                         entity.ReportsToEmployee = null;\r
1695                 }\r
1696 \r
1697                 private void Orders_Attach(Order entity)\r
1698                 {\r
1699                         entity.Employee = this;\r
1700                 }\r
1701 \r
1702                 private void Orders_Detach(Order entity)\r
1703                 {\r
1704                         entity.Employee = null;\r
1705                 }\r
1706 \r
1707 \r
1708                 #endregion\r
1709 \r
1710                 #region ctor\r
1711 \r
1712                 public Employee()\r
1713                 {\r
1714                         _employeeTerritories = new EntitySet<EmployeeTerritory>(EmployeeTerritories_Attach, EmployeeTerritories_Detach);\r
1715                         _employees = new EntitySet<Employee>(Employees_Attach, Employees_Detach);\r
1716                         _orders = new EntitySet<Order>(Orders_Attach, Orders_Detach);\r
1717                         _reportsToEmployee = new EntityRef<Employee>();\r
1718                         OnCreated();\r
1719                 }\r
1720 \r
1721                 #endregion\r
1722 \r
1723         }\r
1724 \r
1725         [Table(Name = "main.EmployeeTerritories")]\r
1726         public partial class EmployeeTerritory : INotifyPropertyChanging, INotifyPropertyChanged\r
1727         {\r
1728                 #region INotifyPropertyChanging handling\r
1729 \r
1730                 public event PropertyChangingEventHandler PropertyChanging;\r
1731 \r
1732                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
1733                 protected virtual void SendPropertyChanging()\r
1734                 {\r
1735                         if (PropertyChanging != null)\r
1736                         {\r
1737                                 PropertyChanging(this, emptyChangingEventArgs);\r
1738                         }\r
1739                 }\r
1740 \r
1741                 #endregion\r
1742 \r
1743                 #region INotifyPropertyChanged handling\r
1744 \r
1745                 public event PropertyChangedEventHandler PropertyChanged;\r
1746 \r
1747                 protected virtual void SendPropertyChanged(string propertyName)\r
1748                 {\r
1749                         if (PropertyChanged != null)\r
1750                         {\r
1751                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
1752                         }\r
1753                 }\r
1754 \r
1755                 #endregion\r
1756 \r
1757                 #region Extensibility Method Definitions\r
1758 \r
1759                 partial void OnCreated();\r
1760                 partial void OnEmployeeIDChanged();\r
1761                 partial void OnEmployeeIDChanging(int value);\r
1762                 partial void OnTerritoryIDChanged();\r
1763                 partial void OnTerritoryIDChanging(string value);\r
1764 \r
1765                 #endregion\r
1766 \r
1767                 #region int EmployeeID\r
1768 \r
1769                 private int _employeeID;\r
1770                 [DebuggerNonUserCode]\r
1771                 [Column(Storage = "_employeeID", Name = "EmployeeID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
1772                 public int EmployeeID\r
1773                 {\r
1774                         get\r
1775                         {\r
1776                                 return _employeeID;\r
1777                         }\r
1778                         set\r
1779                         {\r
1780                                 if (value != _employeeID)\r
1781                                 {\r
1782                                         if (_employee.HasLoadedOrAssignedValue)\r
1783                                         {\r
1784                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
1785                                         }\r
1786                                         OnEmployeeIDChanging(value);\r
1787                                         SendPropertyChanging();\r
1788                                         _employeeID = value;\r
1789                                         SendPropertyChanged("EmployeeID");\r
1790                                         OnEmployeeIDChanged();\r
1791                                 }\r
1792                         }\r
1793                 }\r
1794 \r
1795                 #endregion\r
1796 \r
1797                 #region string TerritoryID\r
1798 \r
1799                 private string _territoryID;\r
1800                 [DebuggerNonUserCode]\r
1801                 [Column(Storage = "_territoryID", Name = "TerritoryID", DbType = "nvarchar", IsPrimaryKey = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
1802                 public string TerritoryID\r
1803                 {\r
1804                         get\r
1805                         {\r
1806                                 return _territoryID;\r
1807                         }\r
1808                         set\r
1809                         {\r
1810                                 if (value != _territoryID)\r
1811                                 {\r
1812                                         if (_territory.HasLoadedOrAssignedValue)\r
1813                                         {\r
1814                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
1815                                         }\r
1816                                         OnTerritoryIDChanging(value);\r
1817                                         SendPropertyChanging();\r
1818                                         _territoryID = value;\r
1819                                         SendPropertyChanged("TerritoryID");\r
1820                                         OnTerritoryIDChanged();\r
1821                                 }\r
1822                         }\r
1823                 }\r
1824 \r
1825                 #endregion\r
1826 \r
1827                 #region Parents\r
1828 \r
1829                 private EntityRef<Territory> _territory;\r
1830                 [Association(Storage = "_territory", OtherKey = "TerritoryID", ThisKey = "TerritoryID", Name = "fk_EmployeeTerritories_0", IsForeignKey = true)]\r
1831                 [DebuggerNonUserCode]\r
1832                 public Territory Territory\r
1833                 {\r
1834                         get\r
1835                         {\r
1836                                 return _territory.Entity;\r
1837                         }\r
1838                         set\r
1839                         {\r
1840                                 if (value != _territory.Entity)\r
1841                                 {\r
1842                                         if (_territory.Entity != null)\r
1843                                         {\r
1844                                                 var previousTerritory = _territory.Entity;\r
1845                                                 _territory.Entity = null;\r
1846                                                 previousTerritory.EmployeeTerritories.Remove(this);\r
1847                                         }\r
1848                                         _territory.Entity = value;\r
1849                                         if (value != null)\r
1850                                         {\r
1851                                                 value.EmployeeTerritories.Add(this);\r
1852                                                 _territoryID = value.TerritoryID;\r
1853                                         }\r
1854                                         else\r
1855                                         {\r
1856                                                 _territoryID = default(string);\r
1857                                         }\r
1858                                 }\r
1859                         }\r
1860                 }\r
1861 \r
1862                 private EntityRef<Employee> _employee;\r
1863                 [Association(Storage = "_employee", OtherKey = "EmployeeID", ThisKey = "EmployeeID", Name = "fk_EmployeeTerritories_1", IsForeignKey = true)]\r
1864                 [DebuggerNonUserCode]\r
1865                 public Employee Employee\r
1866                 {\r
1867                         get\r
1868                         {\r
1869                                 return _employee.Entity;\r
1870                         }\r
1871                         set\r
1872                         {\r
1873                                 if (value != _employee.Entity)\r
1874                                 {\r
1875                                         if (_employee.Entity != null)\r
1876                                         {\r
1877                                                 var previousEmployee = _employee.Entity;\r
1878                                                 _employee.Entity = null;\r
1879                                                 previousEmployee.EmployeeTerritories.Remove(this);\r
1880                                         }\r
1881                                         _employee.Entity = value;\r
1882                                         if (value != null)\r
1883                                         {\r
1884                                                 value.EmployeeTerritories.Add(this);\r
1885                                                 _employeeID = value.EmployeeID;\r
1886                                         }\r
1887                                         else\r
1888                                         {\r
1889                                                 _employeeID = default(int);\r
1890                                         }\r
1891                                 }\r
1892                         }\r
1893                 }\r
1894 \r
1895 \r
1896                 #endregion\r
1897 \r
1898                 #region ctor\r
1899 \r
1900                 public EmployeeTerritory()\r
1901                 {\r
1902                         _territory = new EntityRef<Territory>();\r
1903                         _employee = new EntityRef<Employee>();\r
1904                         OnCreated();\r
1905                 }\r
1906 \r
1907                 #endregion\r
1908 \r
1909         }\r
1910 \r
1911         [Table(Name = "main.Orders")]\r
1912         public partial class Order : INotifyPropertyChanging, INotifyPropertyChanged\r
1913         {\r
1914                 #region INotifyPropertyChanging handling\r
1915 \r
1916                 public event PropertyChangingEventHandler PropertyChanging;\r
1917 \r
1918                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
1919                 protected virtual void SendPropertyChanging()\r
1920                 {\r
1921                         if (PropertyChanging != null)\r
1922                         {\r
1923                                 PropertyChanging(this, emptyChangingEventArgs);\r
1924                         }\r
1925                 }\r
1926 \r
1927                 #endregion\r
1928 \r
1929                 #region INotifyPropertyChanged handling\r
1930 \r
1931                 public event PropertyChangedEventHandler PropertyChanged;\r
1932 \r
1933                 protected virtual void SendPropertyChanged(string propertyName)\r
1934                 {\r
1935                         if (PropertyChanged != null)\r
1936                         {\r
1937                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
1938                         }\r
1939                 }\r
1940 \r
1941                 #endregion\r
1942 \r
1943                 #region Extensibility Method Definitions\r
1944 \r
1945                 partial void OnCreated();\r
1946                 partial void OnCustomerIDChanged();\r
1947                 partial void OnCustomerIDChanging(string value);\r
1948                 partial void OnEmployeeIDChanged();\r
1949                 partial void OnEmployeeIDChanging(int? value);\r
1950                 partial void OnFreightChanged();\r
1951                 partial void OnFreightChanging(decimal? value);\r
1952                 partial void OnOrderDateChanged();\r
1953                 partial void OnOrderDateChanging(DateTime? value);\r
1954                 partial void OnOrderIDChanged();\r
1955                 partial void OnOrderIDChanging(int value);\r
1956                 partial void OnRequiredDateChanged();\r
1957                 partial void OnRequiredDateChanging(DateTime? value);\r
1958                 partial void OnShipAddressChanged();\r
1959                 partial void OnShipAddressChanging(string value);\r
1960                 partial void OnShipCityChanged();\r
1961                 partial void OnShipCityChanging(string value);\r
1962                 partial void OnShipCountryChanged();\r
1963                 partial void OnShipCountryChanging(string value);\r
1964                 partial void OnShipNameChanged();\r
1965                 partial void OnShipNameChanging(string value);\r
1966                 partial void OnShippedDateChanged();\r
1967                 partial void OnShippedDateChanging(DateTime? value);\r
1968                 partial void OnShipPostalCodeChanged();\r
1969                 partial void OnShipPostalCodeChanging(string value);\r
1970                 partial void OnShipRegionChanged();\r
1971                 partial void OnShipRegionChanging(string value);\r
1972                 partial void OnShipViaChanged();\r
1973                 partial void OnShipViaChanging(int? value);\r
1974 \r
1975                 #endregion\r
1976 \r
1977                 #region string CustomerID\r
1978 \r
1979                 private string _customerID;\r
1980                 [DebuggerNonUserCode]\r
1981                 [Column(Storage = "_customerID", Name = "CustomerID", DbType = "nchar (5)", AutoSync = AutoSync.Never)]\r
1982                 public string CustomerID\r
1983                 {\r
1984                         get\r
1985                         {\r
1986                                 return _customerID;\r
1987                         }\r
1988                         set\r
1989                         {\r
1990                                 if (value != _customerID)\r
1991                                 {\r
1992                                         if (_customer.HasLoadedOrAssignedValue)\r
1993                                         {\r
1994                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
1995                                         }\r
1996                                         OnCustomerIDChanging(value);\r
1997                                         SendPropertyChanging();\r
1998                                         _customerID = value;\r
1999                                         SendPropertyChanged("CustomerID");\r
2000                                         OnCustomerIDChanged();\r
2001                                 }\r
2002                         }\r
2003                 }\r
2004 \r
2005                 #endregion\r
2006 \r
2007                 #region int? EmployeeID\r
2008 \r
2009                 private int? _employeeID;\r
2010                 [DebuggerNonUserCode]\r
2011                 [Column(Storage = "_employeeID", Name = "EmployeeID", DbType = "INTEGER", AutoSync = AutoSync.Never)]\r
2012                 public int? EmployeeID\r
2013                 {\r
2014                         get\r
2015                         {\r
2016                                 return _employeeID;\r
2017                         }\r
2018                         set\r
2019                         {\r
2020                                 if (value != _employeeID)\r
2021                                 {\r
2022                                         if (_employee.HasLoadedOrAssignedValue)\r
2023                                         {\r
2024                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
2025                                         }\r
2026                                         OnEmployeeIDChanging(value);\r
2027                                         SendPropertyChanging();\r
2028                                         _employeeID = value;\r
2029                                         SendPropertyChanged("EmployeeID");\r
2030                                         OnEmployeeIDChanged();\r
2031                                 }\r
2032                         }\r
2033                 }\r
2034 \r
2035                 #endregion\r
2036 \r
2037                 #region decimal? Freight\r
2038 \r
2039                 private decimal? _freight;\r
2040                 [DebuggerNonUserCode]\r
2041                 [Column(Storage = "_freight", Name = "Freight", DbType = "money", AutoSync = AutoSync.Never)]\r
2042                 public decimal? Freight\r
2043                 {\r
2044                         get\r
2045                         {\r
2046                                 return _freight;\r
2047                         }\r
2048                         set\r
2049                         {\r
2050                                 if (value != _freight)\r
2051                                 {\r
2052                                         OnFreightChanging(value);\r
2053                                         SendPropertyChanging();\r
2054                                         _freight = value;\r
2055                                         SendPropertyChanged("Freight");\r
2056                                         OnFreightChanged();\r
2057                                 }\r
2058                         }\r
2059                 }\r
2060 \r
2061                 #endregion\r
2062 \r
2063                 #region DateTime? OrderDate\r
2064 \r
2065                 private DateTime? _orderDate;\r
2066                 [DebuggerNonUserCode]\r
2067                 [Column(Storage = "_orderDate", Name = "OrderDate", DbType = "datetime", AutoSync = AutoSync.Never)]\r
2068                 public DateTime? OrderDate\r
2069                 {\r
2070                         get\r
2071                         {\r
2072                                 return _orderDate;\r
2073                         }\r
2074                         set\r
2075                         {\r
2076                                 if (value != _orderDate)\r
2077                                 {\r
2078                                         OnOrderDateChanging(value);\r
2079                                         SendPropertyChanging();\r
2080                                         _orderDate = value;\r
2081                                         SendPropertyChanged("OrderDate");\r
2082                                         OnOrderDateChanged();\r
2083                                 }\r
2084                         }\r
2085                 }\r
2086 \r
2087                 #endregion\r
2088 \r
2089                 #region int OrderID\r
2090 \r
2091                 private int _orderID;\r
2092                 [DebuggerNonUserCode]\r
2093                 [Column(Storage = "_orderID", Name = "OrderID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
2094                 public int OrderID\r
2095                 {\r
2096                         get\r
2097                         {\r
2098                                 return _orderID;\r
2099                         }\r
2100                         set\r
2101                         {\r
2102                                 if (value != _orderID)\r
2103                                 {\r
2104                                         OnOrderIDChanging(value);\r
2105                                         SendPropertyChanging();\r
2106                                         _orderID = value;\r
2107                                         SendPropertyChanged("OrderID");\r
2108                                         OnOrderIDChanged();\r
2109                                 }\r
2110                         }\r
2111                 }\r
2112 \r
2113                 #endregion\r
2114 \r
2115                 #region DateTime? RequiredDate\r
2116 \r
2117                 private DateTime? _requiredDate;\r
2118                 [DebuggerNonUserCode]\r
2119                 [Column(Storage = "_requiredDate", Name = "RequiredDate", DbType = "datetime", AutoSync = AutoSync.Never)]\r
2120                 public DateTime? RequiredDate\r
2121                 {\r
2122                         get\r
2123                         {\r
2124                                 return _requiredDate;\r
2125                         }\r
2126                         set\r
2127                         {\r
2128                                 if (value != _requiredDate)\r
2129                                 {\r
2130                                         OnRequiredDateChanging(value);\r
2131                                         SendPropertyChanging();\r
2132                                         _requiredDate = value;\r
2133                                         SendPropertyChanged("RequiredDate");\r
2134                                         OnRequiredDateChanged();\r
2135                                 }\r
2136                         }\r
2137                 }\r
2138 \r
2139                 #endregion\r
2140 \r
2141                 #region string ShipAddress\r
2142 \r
2143                 private string _shipAddress;\r
2144                 [DebuggerNonUserCode]\r
2145                 [Column(Storage = "_shipAddress", Name = "ShipAddress", DbType = "nvarchar (60)", AutoSync = AutoSync.Never)]\r
2146                 public string ShipAddress\r
2147                 {\r
2148                         get\r
2149                         {\r
2150                                 return _shipAddress;\r
2151                         }\r
2152                         set\r
2153                         {\r
2154                                 if (value != _shipAddress)\r
2155                                 {\r
2156                                         OnShipAddressChanging(value);\r
2157                                         SendPropertyChanging();\r
2158                                         _shipAddress = value;\r
2159                                         SendPropertyChanged("ShipAddress");\r
2160                                         OnShipAddressChanged();\r
2161                                 }\r
2162                         }\r
2163                 }\r
2164 \r
2165                 #endregion\r
2166 \r
2167                 #region string ShipCity\r
2168 \r
2169                 private string _shipCity;\r
2170                 [DebuggerNonUserCode]\r
2171                 [Column(Storage = "_shipCity", Name = "ShipCity", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
2172                 public string ShipCity\r
2173                 {\r
2174                         get\r
2175                         {\r
2176                                 return _shipCity;\r
2177                         }\r
2178                         set\r
2179                         {\r
2180                                 if (value != _shipCity)\r
2181                                 {\r
2182                                         OnShipCityChanging(value);\r
2183                                         SendPropertyChanging();\r
2184                                         _shipCity = value;\r
2185                                         SendPropertyChanged("ShipCity");\r
2186                                         OnShipCityChanged();\r
2187                                 }\r
2188                         }\r
2189                 }\r
2190 \r
2191                 #endregion\r
2192 \r
2193                 #region string ShipCountry\r
2194 \r
2195                 private string _shipCountry;\r
2196                 [DebuggerNonUserCode]\r
2197                 [Column(Storage = "_shipCountry", Name = "ShipCountry", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
2198                 public string ShipCountry\r
2199                 {\r
2200                         get\r
2201                         {\r
2202                                 return _shipCountry;\r
2203                         }\r
2204                         set\r
2205                         {\r
2206                                 if (value != _shipCountry)\r
2207                                 {\r
2208                                         OnShipCountryChanging(value);\r
2209                                         SendPropertyChanging();\r
2210                                         _shipCountry = value;\r
2211                                         SendPropertyChanged("ShipCountry");\r
2212                                         OnShipCountryChanged();\r
2213                                 }\r
2214                         }\r
2215                 }\r
2216 \r
2217                 #endregion\r
2218 \r
2219                 #region string ShipName\r
2220 \r
2221                 private string _shipName;\r
2222                 [DebuggerNonUserCode]\r
2223                 [Column(Storage = "_shipName", Name = "ShipName", DbType = "nvarchar (40)", AutoSync = AutoSync.Never)]\r
2224                 public string ShipName\r
2225                 {\r
2226                         get\r
2227                         {\r
2228                                 return _shipName;\r
2229                         }\r
2230                         set\r
2231                         {\r
2232                                 if (value != _shipName)\r
2233                                 {\r
2234                                         OnShipNameChanging(value);\r
2235                                         SendPropertyChanging();\r
2236                                         _shipName = value;\r
2237                                         SendPropertyChanged("ShipName");\r
2238                                         OnShipNameChanged();\r
2239                                 }\r
2240                         }\r
2241                 }\r
2242 \r
2243                 #endregion\r
2244 \r
2245                 #region DateTime? ShippedDate\r
2246 \r
2247                 private DateTime? _shippedDate;\r
2248                 [DebuggerNonUserCode]\r
2249                 [Column(Storage = "_shippedDate", Name = "ShippedDate", DbType = "datetime", AutoSync = AutoSync.Never)]\r
2250                 public DateTime? ShippedDate\r
2251                 {\r
2252                         get\r
2253                         {\r
2254                                 return _shippedDate;\r
2255                         }\r
2256                         set\r
2257                         {\r
2258                                 if (value != _shippedDate)\r
2259                                 {\r
2260                                         OnShippedDateChanging(value);\r
2261                                         SendPropertyChanging();\r
2262                                         _shippedDate = value;\r
2263                                         SendPropertyChanged("ShippedDate");\r
2264                                         OnShippedDateChanged();\r
2265                                 }\r
2266                         }\r
2267                 }\r
2268 \r
2269                 #endregion\r
2270 \r
2271                 #region string ShipPostalCode\r
2272 \r
2273                 private string _shipPostalCode;\r
2274                 [DebuggerNonUserCode]\r
2275                 [Column(Storage = "_shipPostalCode", Name = "ShipPostalCode", DbType = "nvarchar (10)", AutoSync = AutoSync.Never)]\r
2276                 public string ShipPostalCode\r
2277                 {\r
2278                         get\r
2279                         {\r
2280                                 return _shipPostalCode;\r
2281                         }\r
2282                         set\r
2283                         {\r
2284                                 if (value != _shipPostalCode)\r
2285                                 {\r
2286                                         OnShipPostalCodeChanging(value);\r
2287                                         SendPropertyChanging();\r
2288                                         _shipPostalCode = value;\r
2289                                         SendPropertyChanged("ShipPostalCode");\r
2290                                         OnShipPostalCodeChanged();\r
2291                                 }\r
2292                         }\r
2293                 }\r
2294 \r
2295                 #endregion\r
2296 \r
2297                 #region string ShipRegion\r
2298 \r
2299                 private string _shipRegion;\r
2300                 [DebuggerNonUserCode]\r
2301                 [Column(Storage = "_shipRegion", Name = "ShipRegion", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
2302                 public string ShipRegion\r
2303                 {\r
2304                         get\r
2305                         {\r
2306                                 return _shipRegion;\r
2307                         }\r
2308                         set\r
2309                         {\r
2310                                 if (value != _shipRegion)\r
2311                                 {\r
2312                                         OnShipRegionChanging(value);\r
2313                                         SendPropertyChanging();\r
2314                                         _shipRegion = value;\r
2315                                         SendPropertyChanged("ShipRegion");\r
2316                                         OnShipRegionChanged();\r
2317                                 }\r
2318                         }\r
2319                 }\r
2320 \r
2321                 #endregion\r
2322 \r
2323                 #region int? ShipVia\r
2324 \r
2325                 private int? _shipVia;\r
2326                 [DebuggerNonUserCode]\r
2327                 [Column(Storage = "_shipVia", Name = "ShipVia", DbType = "INTEGER", AutoSync = AutoSync.Never)]\r
2328                 public int? ShipVia\r
2329                 {\r
2330                         get\r
2331                         {\r
2332                                 return _shipVia;\r
2333                         }\r
2334                         set\r
2335                         {\r
2336                                 if (value != _shipVia)\r
2337                                 {\r
2338                                         if (_shipper.HasLoadedOrAssignedValue)\r
2339                                         {\r
2340                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
2341                                         }\r
2342                                         OnShipViaChanging(value);\r
2343                                         SendPropertyChanging();\r
2344                                         _shipVia = value;\r
2345                                         SendPropertyChanged("ShipVia");\r
2346                                         OnShipViaChanged();\r
2347                                 }\r
2348                         }\r
2349                 }\r
2350 \r
2351                 #endregion\r
2352 \r
2353                 #region Children\r
2354 \r
2355                 private EntitySet<OrderDetail> _orderDetails;\r
2356                 [Association(Storage = "_orderDetails", OtherKey = "OrderID", ThisKey = "OrderID", Name = "\"fk_Order Details_1\"")]\r
2357                 [DebuggerNonUserCode]\r
2358                 public EntitySet<OrderDetail> OrderDetails\r
2359                 {\r
2360                         get\r
2361                         {\r
2362                                 return _orderDetails;\r
2363                         }\r
2364                         set\r
2365                         {\r
2366                                 _orderDetails = value;\r
2367                         }\r
2368                 }\r
2369 \r
2370 \r
2371                 #endregion\r
2372 \r
2373                 #region Parents\r
2374 \r
2375                 private EntityRef<Shipper> _shipper;\r
2376                 [Association(Storage = "_shipper", OtherKey = "ShipperID", ThisKey = "ShipVia", Name = "fk_Orders_0", IsForeignKey = true)]\r
2377                 [DebuggerNonUserCode]\r
2378                 public Shipper Shipper\r
2379                 {\r
2380                         get\r
2381                         {\r
2382                                 return _shipper.Entity;\r
2383                         }\r
2384                         set\r
2385                         {\r
2386                                 if (value != _shipper.Entity)\r
2387                                 {\r
2388                                         if (_shipper.Entity != null)\r
2389                                         {\r
2390                                                 var previousShipper = _shipper.Entity;\r
2391                                                 _shipper.Entity = null;\r
2392                                                 previousShipper.Orders.Remove(this);\r
2393                                         }\r
2394                                         _shipper.Entity = value;\r
2395                                         if (value != null)\r
2396                                         {\r
2397                                                 value.Orders.Add(this);\r
2398                                                 _shipVia = value.ShipperID;\r
2399                                         }\r
2400                                         else\r
2401                                         {\r
2402                                                 _shipVia = null;\r
2403                                         }\r
2404                                 }\r
2405                         }\r
2406                 }\r
2407 \r
2408                 private EntityRef<Employee> _employee;\r
2409                 [Association(Storage = "_employee", OtherKey = "EmployeeID", ThisKey = "EmployeeID", Name = "fk_Orders_1", IsForeignKey = true)]\r
2410                 [DebuggerNonUserCode]\r
2411                 public Employee Employee\r
2412                 {\r
2413                         get\r
2414                         {\r
2415                                 return _employee.Entity;\r
2416                         }\r
2417                         set\r
2418                         {\r
2419                                 if (value != _employee.Entity)\r
2420                                 {\r
2421                                         if (_employee.Entity != null)\r
2422                                         {\r
2423                                                 var previousEmployee = _employee.Entity;\r
2424                                                 _employee.Entity = null;\r
2425                                                 previousEmployee.Orders.Remove(this);\r
2426                                         }\r
2427                                         _employee.Entity = value;\r
2428                                         if (value != null)\r
2429                                         {\r
2430                                                 value.Orders.Add(this);\r
2431                                                 _employeeID = value.EmployeeID;\r
2432                                         }\r
2433                                         else\r
2434                                         {\r
2435                                                 _employeeID = null;\r
2436                                         }\r
2437                                 }\r
2438                         }\r
2439                 }\r
2440 \r
2441                 private EntityRef<Customer> _customer;\r
2442                 [Association(Storage = "_customer", OtherKey = "CustomerID", ThisKey = "CustomerID", Name = "fk_Orders_2", IsForeignKey = true)]\r
2443                 [DebuggerNonUserCode]\r
2444                 public Customer Customer\r
2445                 {\r
2446                         get\r
2447                         {\r
2448                                 return _customer.Entity;\r
2449                         }\r
2450                         set\r
2451                         {\r
2452                                 if (value != _customer.Entity)\r
2453                                 {\r
2454                                         if (_customer.Entity != null)\r
2455                                         {\r
2456                                                 var previousCustomer = _customer.Entity;\r
2457                                                 _customer.Entity = null;\r
2458                                                 previousCustomer.Orders.Remove(this);\r
2459                                         }\r
2460                                         _customer.Entity = value;\r
2461                                         if (value != null)\r
2462                                         {\r
2463                                                 value.Orders.Add(this);\r
2464                                                 _customerID = value.CustomerID;\r
2465                                         }\r
2466                                         else\r
2467                                         {\r
2468                                                 _customerID = null;\r
2469                                         }\r
2470                                 }\r
2471                         }\r
2472                 }\r
2473 \r
2474 \r
2475                 #endregion\r
2476 \r
2477                 #region Attachement handlers\r
2478 \r
2479                 private void OrderDetails_Attach(OrderDetail entity)\r
2480                 {\r
2481                         entity.Order = this;\r
2482                 }\r
2483 \r
2484                 private void OrderDetails_Detach(OrderDetail entity)\r
2485                 {\r
2486                         entity.Order = null;\r
2487                 }\r
2488 \r
2489 \r
2490                 #endregion\r
2491 \r
2492                 #region ctor\r
2493 \r
2494                 public Order()\r
2495                 {\r
2496                         _orderDetails = new EntitySet<OrderDetail>(OrderDetails_Attach, OrderDetails_Detach);\r
2497                         _shipper = new EntityRef<Shipper>();\r
2498                         _employee = new EntityRef<Employee>();\r
2499                         _customer = new EntityRef<Customer>();\r
2500                         OnCreated();\r
2501                 }\r
2502 \r
2503                 #endregion\r
2504 \r
2505         }\r
2506 \r
2507         [Table(Name = "main.\"Order Details\"")]\r
2508         public partial class OrderDetail : INotifyPropertyChanging, INotifyPropertyChanged\r
2509         {\r
2510                 #region INotifyPropertyChanging handling\r
2511 \r
2512                 public event PropertyChangingEventHandler PropertyChanging;\r
2513 \r
2514                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
2515                 protected virtual void SendPropertyChanging()\r
2516                 {\r
2517                         if (PropertyChanging != null)\r
2518                         {\r
2519                                 PropertyChanging(this, emptyChangingEventArgs);\r
2520                         }\r
2521                 }\r
2522 \r
2523                 #endregion\r
2524 \r
2525                 #region INotifyPropertyChanged handling\r
2526 \r
2527                 public event PropertyChangedEventHandler PropertyChanged;\r
2528 \r
2529                 protected virtual void SendPropertyChanged(string propertyName)\r
2530                 {\r
2531                         if (PropertyChanged != null)\r
2532                         {\r
2533                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
2534                         }\r
2535                 }\r
2536 \r
2537                 #endregion\r
2538 \r
2539                 #region Extensibility Method Definitions\r
2540 \r
2541                 partial void OnCreated();\r
2542                 partial void OnDiscountChanged();\r
2543                 partial void OnDiscountChanging(float value);\r
2544                 partial void OnOrderIDChanged();\r
2545                 partial void OnOrderIDChanging(int value);\r
2546                 partial void OnProductIDChanged();\r
2547                 partial void OnProductIDChanging(int value);\r
2548                 partial void OnQuantityChanged();\r
2549                 partial void OnQuantityChanging(short value);\r
2550                 partial void OnUnitPriceChanged();\r
2551                 partial void OnUnitPriceChanging(decimal value);\r
2552 \r
2553                 #endregion\r
2554 \r
2555                 #region float Discount\r
2556 \r
2557                 private float _discount;\r
2558                 [DebuggerNonUserCode]\r
2559                 [Column(Storage = "_discount", Name = "Discount", DbType = "real", AutoSync = AutoSync.Never, CanBeNull = false)]\r
2560                 public float Discount\r
2561                 {\r
2562                         get\r
2563                         {\r
2564                                 return _discount;\r
2565                         }\r
2566                         set\r
2567                         {\r
2568                                 if (value != _discount)\r
2569                                 {\r
2570                                         OnDiscountChanging(value);\r
2571                                         SendPropertyChanging();\r
2572                                         _discount = value;\r
2573                                         SendPropertyChanged("Discount");\r
2574                                         OnDiscountChanged();\r
2575                                 }\r
2576                         }\r
2577                 }\r
2578 \r
2579                 #endregion\r
2580 \r
2581                 #region int OrderID\r
2582 \r
2583                 private int _orderID;\r
2584                 [DebuggerNonUserCode]\r
2585                 [Column(Storage = "_orderID", Name = "OrderID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
2586                 public int OrderID\r
2587                 {\r
2588                         get\r
2589                         {\r
2590                                 return _orderID;\r
2591                         }\r
2592                         set\r
2593                         {\r
2594                                 if (value != _orderID)\r
2595                                 {\r
2596                                         if (_order.HasLoadedOrAssignedValue)\r
2597                                         {\r
2598                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
2599                                         }\r
2600                                         OnOrderIDChanging(value);\r
2601                                         SendPropertyChanging();\r
2602                                         _orderID = value;\r
2603                                         SendPropertyChanged("OrderID");\r
2604                                         OnOrderIDChanged();\r
2605                                 }\r
2606                         }\r
2607                 }\r
2608 \r
2609                 #endregion\r
2610 \r
2611                 #region int ProductID\r
2612 \r
2613                 private int _productID;\r
2614                 [DebuggerNonUserCode]\r
2615                 [Column(Storage = "_productID", Name = "ProductID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
2616                 public int ProductID\r
2617                 {\r
2618                         get\r
2619                         {\r
2620                                 return _productID;\r
2621                         }\r
2622                         set\r
2623                         {\r
2624                                 if (value != _productID)\r
2625                                 {\r
2626                                         if (_product.HasLoadedOrAssignedValue)\r
2627                                         {\r
2628                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
2629                                         }\r
2630                                         OnProductIDChanging(value);\r
2631                                         SendPropertyChanging();\r
2632                                         _productID = value;\r
2633                                         SendPropertyChanged("ProductID");\r
2634                                         OnProductIDChanged();\r
2635                                 }\r
2636                         }\r
2637                 }\r
2638 \r
2639                 #endregion\r
2640 \r
2641                 #region short Quantity\r
2642 \r
2643                 private short _quantity;\r
2644                 [DebuggerNonUserCode]\r
2645                 [Column(Storage = "_quantity", Name = "Quantity", DbType = "smallint", AutoSync = AutoSync.Never, CanBeNull = false)]\r
2646                 public short Quantity\r
2647                 {\r
2648                         get\r
2649                         {\r
2650                                 return _quantity;\r
2651                         }\r
2652                         set\r
2653                         {\r
2654                                 if (value != _quantity)\r
2655                                 {\r
2656                                         OnQuantityChanging(value);\r
2657                                         SendPropertyChanging();\r
2658                                         _quantity = value;\r
2659                                         SendPropertyChanged("Quantity");\r
2660                                         OnQuantityChanged();\r
2661                                 }\r
2662                         }\r
2663                 }\r
2664 \r
2665                 #endregion\r
2666 \r
2667                 #region decimal UnitPrice\r
2668 \r
2669                 private decimal _unitPrice;\r
2670                 [DebuggerNonUserCode]\r
2671                 [Column(Storage = "_unitPrice", Name = "UnitPrice", DbType = "money", AutoSync = AutoSync.Never, CanBeNull = false)]\r
2672                 public decimal UnitPrice\r
2673                 {\r
2674                         get\r
2675                         {\r
2676                                 return _unitPrice;\r
2677                         }\r
2678                         set\r
2679                         {\r
2680                                 if (value != _unitPrice)\r
2681                                 {\r
2682                                         OnUnitPriceChanging(value);\r
2683                                         SendPropertyChanging();\r
2684                                         _unitPrice = value;\r
2685                                         SendPropertyChanged("UnitPrice");\r
2686                                         OnUnitPriceChanged();\r
2687                                 }\r
2688                         }\r
2689                 }\r
2690 \r
2691                 #endregion\r
2692 \r
2693                 #region Parents\r
2694 \r
2695                 private EntityRef<Product> _product;\r
2696                 [Association(Storage = "_product", OtherKey = "ProductID", ThisKey = "ProductID", Name = "\"fk_Order Details_0\"", IsForeignKey = true)]\r
2697                 [DebuggerNonUserCode]\r
2698                 public Product Product\r
2699                 {\r
2700                         get\r
2701                         {\r
2702                                 return _product.Entity;\r
2703                         }\r
2704                         set\r
2705                         {\r
2706                                 if (value != _product.Entity)\r
2707                                 {\r
2708                                         if (_product.Entity != null)\r
2709                                         {\r
2710                                                 var previousProduct = _product.Entity;\r
2711                                                 _product.Entity = null;\r
2712                                                 previousProduct.OrderDetails.Remove(this);\r
2713                                         }\r
2714                                         _product.Entity = value;\r
2715                                         if (value != null)\r
2716                                         {\r
2717                                                 value.OrderDetails.Add(this);\r
2718                                                 _productID = value.ProductID;\r
2719                                         }\r
2720                                         else\r
2721                                         {\r
2722                                                 _productID = default(int);\r
2723                                         }\r
2724                                 }\r
2725                         }\r
2726                 }\r
2727 \r
2728                 private EntityRef<Order> _order;\r
2729                 [Association(Storage = "_order", OtherKey = "OrderID", ThisKey = "OrderID", Name = "\"fk_Order Details_1\"", IsForeignKey = true)]\r
2730                 [DebuggerNonUserCode]\r
2731                 public Order Order\r
2732                 {\r
2733                         get\r
2734                         {\r
2735                                 return _order.Entity;\r
2736                         }\r
2737                         set\r
2738                         {\r
2739                                 if (value != _order.Entity)\r
2740                                 {\r
2741                                         if (_order.Entity != null)\r
2742                                         {\r
2743                                                 var previousOrder = _order.Entity;\r
2744                                                 _order.Entity = null;\r
2745                                                 previousOrder.OrderDetails.Remove(this);\r
2746                                         }\r
2747                                         _order.Entity = value;\r
2748                                         if (value != null)\r
2749                                         {\r
2750                                                 value.OrderDetails.Add(this);\r
2751                                                 _orderID = value.OrderID;\r
2752                                         }\r
2753                                         else\r
2754                                         {\r
2755                                                 _orderID = default(int);\r
2756                                         }\r
2757                                 }\r
2758                         }\r
2759                 }\r
2760 \r
2761 \r
2762                 #endregion\r
2763 \r
2764                 #region ctor\r
2765 \r
2766                 public OrderDetail()\r
2767                 {\r
2768                         _product = new EntityRef<Product>();\r
2769                         _order = new EntityRef<Order>();\r
2770                         OnCreated();\r
2771                 }\r
2772 \r
2773                 #endregion\r
2774 \r
2775         }\r
2776 \r
2777         [Table(Name = "main.Products")]\r
2778         public partial class Product : INotifyPropertyChanging, INotifyPropertyChanged\r
2779         {\r
2780                 #region INotifyPropertyChanging handling\r
2781 \r
2782                 public event PropertyChangingEventHandler PropertyChanging;\r
2783 \r
2784                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
2785                 protected virtual void SendPropertyChanging()\r
2786                 {\r
2787                         if (PropertyChanging != null)\r
2788                         {\r
2789                                 PropertyChanging(this, emptyChangingEventArgs);\r
2790                         }\r
2791                 }\r
2792 \r
2793                 #endregion\r
2794 \r
2795                 #region INotifyPropertyChanged handling\r
2796 \r
2797                 public event PropertyChangedEventHandler PropertyChanged;\r
2798 \r
2799                 protected virtual void SendPropertyChanged(string propertyName)\r
2800                 {\r
2801                         if (PropertyChanged != null)\r
2802                         {\r
2803                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
2804                         }\r
2805                 }\r
2806 \r
2807                 #endregion\r
2808 \r
2809                 #region Extensibility Method Definitions\r
2810 \r
2811                 partial void OnCreated();\r
2812                 partial void OnCategoryIDChanged();\r
2813                 partial void OnCategoryIDChanging(int? value);\r
2814                 partial void OnDiscontinuedChanged();\r
2815                 partial void OnDiscontinuedChanging(bool value);\r
2816                 partial void OnProductIDChanged();\r
2817                 partial void OnProductIDChanging(int value);\r
2818                 partial void OnProductNameChanged();\r
2819                 partial void OnProductNameChanging(string value);\r
2820                 partial void OnQuantityPerUnitChanged();\r
2821                 partial void OnQuantityPerUnitChanging(string value);\r
2822                 partial void OnReorderLevelChanged();\r
2823                 partial void OnReorderLevelChanging(short? value);\r
2824                 partial void OnSupplierIDChanged();\r
2825                 partial void OnSupplierIDChanging(int? value);\r
2826                 partial void OnUnitPriceChanged();\r
2827                 partial void OnUnitPriceChanging(decimal? value);\r
2828                 partial void OnUnitsInStockChanged();\r
2829                 partial void OnUnitsInStockChanging(short? value);\r
2830                 partial void OnUnitsOnOrderChanged();\r
2831                 partial void OnUnitsOnOrderChanging(short? value);\r
2832 \r
2833                 #endregion\r
2834 \r
2835                 #region int? CategoryID\r
2836 \r
2837                 private int? _categoryID;\r
2838                 [DebuggerNonUserCode]\r
2839                 [Column(Storage = "_categoryID", Name = "CategoryID", DbType = "INTEGER", AutoSync = AutoSync.Never)]\r
2840                 public int? CategoryID\r
2841                 {\r
2842                         get\r
2843                         {\r
2844                                 return _categoryID;\r
2845                         }\r
2846                         set\r
2847                         {\r
2848                                 if (value != _categoryID)\r
2849                                 {\r
2850                                         if (_category.HasLoadedOrAssignedValue)\r
2851                                         {\r
2852                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
2853                                         }\r
2854                                         OnCategoryIDChanging(value);\r
2855                                         SendPropertyChanging();\r
2856                                         _categoryID = value;\r
2857                                         SendPropertyChanged("CategoryID");\r
2858                                         OnCategoryIDChanged();\r
2859                                 }\r
2860                         }\r
2861                 }\r
2862 \r
2863                 #endregion\r
2864 \r
2865                 #region bool Discontinued\r
2866 \r
2867                 private bool _discontinued;\r
2868                 [DebuggerNonUserCode]\r
2869                 [Column(Storage = "_discontinued", Name = "Discontinued", DbType = "bit", AutoSync = AutoSync.Never, CanBeNull = false)]\r
2870                 public bool Discontinued\r
2871                 {\r
2872                         get\r
2873                         {\r
2874                                 return _discontinued;\r
2875                         }\r
2876                         set\r
2877                         {\r
2878                                 if (value != _discontinued)\r
2879                                 {\r
2880                                         OnDiscontinuedChanging(value);\r
2881                                         SendPropertyChanging();\r
2882                                         _discontinued = value;\r
2883                                         SendPropertyChanged("Discontinued");\r
2884                                         OnDiscontinuedChanged();\r
2885                                 }\r
2886                         }\r
2887                 }\r
2888 \r
2889                 #endregion\r
2890 \r
2891                 #region int ProductID\r
2892 \r
2893                 private int _productID;\r
2894                 [DebuggerNonUserCode]\r
2895                 [Column(Storage = "_productID", Name = "ProductID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
2896                 public int ProductID\r
2897                 {\r
2898                         get\r
2899                         {\r
2900                                 return _productID;\r
2901                         }\r
2902                         set\r
2903                         {\r
2904                                 if (value != _productID)\r
2905                                 {\r
2906                                         OnProductIDChanging(value);\r
2907                                         SendPropertyChanging();\r
2908                                         _productID = value;\r
2909                                         SendPropertyChanged("ProductID");\r
2910                                         OnProductIDChanged();\r
2911                                 }\r
2912                         }\r
2913                 }\r
2914 \r
2915                 #endregion\r
2916 \r
2917                 #region string ProductName\r
2918 \r
2919                 private string _productName;\r
2920                 [DebuggerNonUserCode]\r
2921                 [Column(Storage = "_productName", Name = "ProductName", DbType = "nvarchar (40)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
2922                 public string ProductName\r
2923                 {\r
2924                         get\r
2925                         {\r
2926                                 return _productName;\r
2927                         }\r
2928                         set\r
2929                         {\r
2930                                 if (value != _productName)\r
2931                                 {\r
2932                                         OnProductNameChanging(value);\r
2933                                         SendPropertyChanging();\r
2934                                         _productName = value;\r
2935                                         SendPropertyChanged("ProductName");\r
2936                                         OnProductNameChanged();\r
2937                                 }\r
2938                         }\r
2939                 }\r
2940 \r
2941                 #endregion\r
2942 \r
2943                 #region string QuantityPerUnit\r
2944 \r
2945                 private string _quantityPerUnit;\r
2946                 [DebuggerNonUserCode]\r
2947                 [Column(Storage = "_quantityPerUnit", Name = "QuantityPerUnit", DbType = "nvarchar (20)", AutoSync = AutoSync.Never)]\r
2948                 public string QuantityPerUnit\r
2949                 {\r
2950                         get\r
2951                         {\r
2952                                 return _quantityPerUnit;\r
2953                         }\r
2954                         set\r
2955                         {\r
2956                                 if (value != _quantityPerUnit)\r
2957                                 {\r
2958                                         OnQuantityPerUnitChanging(value);\r
2959                                         SendPropertyChanging();\r
2960                                         _quantityPerUnit = value;\r
2961                                         SendPropertyChanged("QuantityPerUnit");\r
2962                                         OnQuantityPerUnitChanged();\r
2963                                 }\r
2964                         }\r
2965                 }\r
2966 \r
2967                 #endregion\r
2968 \r
2969                 #region short? ReorderLevel\r
2970 \r
2971                 private short? _reorderLevel;\r
2972                 [DebuggerNonUserCode]\r
2973                 [Column(Storage = "_reorderLevel", Name = "ReorderLevel", DbType = "smallint", AutoSync = AutoSync.Never)]\r
2974                 public short? ReorderLevel\r
2975                 {\r
2976                         get\r
2977                         {\r
2978                                 return _reorderLevel;\r
2979                         }\r
2980                         set\r
2981                         {\r
2982                                 if (value != _reorderLevel)\r
2983                                 {\r
2984                                         OnReorderLevelChanging(value);\r
2985                                         SendPropertyChanging();\r
2986                                         _reorderLevel = value;\r
2987                                         SendPropertyChanged("ReorderLevel");\r
2988                                         OnReorderLevelChanged();\r
2989                                 }\r
2990                         }\r
2991                 }\r
2992 \r
2993                 #endregion\r
2994 \r
2995                 #region int? SupplierID\r
2996 \r
2997                 private int? _supplierID;\r
2998                 [DebuggerNonUserCode]\r
2999                 [Column(Storage = "_supplierID", Name = "SupplierID", DbType = "INTEGER", AutoSync = AutoSync.Never)]\r
3000                 public int? SupplierID\r
3001                 {\r
3002                         get\r
3003                         {\r
3004                                 return _supplierID;\r
3005                         }\r
3006                         set\r
3007                         {\r
3008                                 if (value != _supplierID)\r
3009                                 {\r
3010                                         if (_supplier.HasLoadedOrAssignedValue)\r
3011                                         {\r
3012                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
3013                                         }\r
3014                                         OnSupplierIDChanging(value);\r
3015                                         SendPropertyChanging();\r
3016                                         _supplierID = value;\r
3017                                         SendPropertyChanged("SupplierID");\r
3018                                         OnSupplierIDChanged();\r
3019                                 }\r
3020                         }\r
3021                 }\r
3022 \r
3023                 #endregion\r
3024 \r
3025                 #region decimal? UnitPrice\r
3026 \r
3027                 private decimal? _unitPrice;\r
3028                 [DebuggerNonUserCode]\r
3029                 [Column(Storage = "_unitPrice", Name = "UnitPrice", DbType = "money", AutoSync = AutoSync.Never)]\r
3030                 public decimal? UnitPrice\r
3031                 {\r
3032                         get\r
3033                         {\r
3034                                 return _unitPrice;\r
3035                         }\r
3036                         set\r
3037                         {\r
3038                                 if (value != _unitPrice)\r
3039                                 {\r
3040                                         OnUnitPriceChanging(value);\r
3041                                         SendPropertyChanging();\r
3042                                         _unitPrice = value;\r
3043                                         SendPropertyChanged("UnitPrice");\r
3044                                         OnUnitPriceChanged();\r
3045                                 }\r
3046                         }\r
3047                 }\r
3048 \r
3049                 #endregion\r
3050 \r
3051                 #region short? UnitsInStock\r
3052 \r
3053                 private short? _unitsInStock;\r
3054                 [DebuggerNonUserCode]\r
3055                 [Column(Storage = "_unitsInStock", Name = "UnitsInStock", DbType = "smallint", AutoSync = AutoSync.Never)]\r
3056                 public short? UnitsInStock\r
3057                 {\r
3058                         get\r
3059                         {\r
3060                                 return _unitsInStock;\r
3061                         }\r
3062                         set\r
3063                         {\r
3064                                 if (value != _unitsInStock)\r
3065                                 {\r
3066                                         OnUnitsInStockChanging(value);\r
3067                                         SendPropertyChanging();\r
3068                                         _unitsInStock = value;\r
3069                                         SendPropertyChanged("UnitsInStock");\r
3070                                         OnUnitsInStockChanged();\r
3071                                 }\r
3072                         }\r
3073                 }\r
3074 \r
3075                 #endregion\r
3076 \r
3077                 #region short? UnitsOnOrder\r
3078 \r
3079                 private short? _unitsOnOrder;\r
3080                 [DebuggerNonUserCode]\r
3081                 [Column(Storage = "_unitsOnOrder", Name = "UnitsOnOrder", DbType = "smallint", AutoSync = AutoSync.Never)]\r
3082                 public short? UnitsOnOrder\r
3083                 {\r
3084                         get\r
3085                         {\r
3086                                 return _unitsOnOrder;\r
3087                         }\r
3088                         set\r
3089                         {\r
3090                                 if (value != _unitsOnOrder)\r
3091                                 {\r
3092                                         OnUnitsOnOrderChanging(value);\r
3093                                         SendPropertyChanging();\r
3094                                         _unitsOnOrder = value;\r
3095                                         SendPropertyChanged("UnitsOnOrder");\r
3096                                         OnUnitsOnOrderChanged();\r
3097                                 }\r
3098                         }\r
3099                 }\r
3100 \r
3101                 #endregion\r
3102 \r
3103                 #region Children\r
3104 \r
3105                 private EntitySet<OrderDetail> _orderDetails;\r
3106                 [Association(Storage = "_orderDetails", OtherKey = "ProductID", ThisKey = "ProductID", Name = "\"fk_Order Details_0\"")]\r
3107                 [DebuggerNonUserCode]\r
3108                 public EntitySet<OrderDetail> OrderDetails\r
3109                 {\r
3110                         get\r
3111                         {\r
3112                                 return _orderDetails;\r
3113                         }\r
3114                         set\r
3115                         {\r
3116                                 _orderDetails = value;\r
3117                         }\r
3118                 }\r
3119 \r
3120 \r
3121                 #endregion\r
3122 \r
3123                 #region Parents\r
3124 \r
3125                 private EntityRef<Supplier> _supplier;\r
3126                 [Association(Storage = "_supplier", OtherKey = "SupplierID", ThisKey = "SupplierID", Name = "fk_Products_0", IsForeignKey = true)]\r
3127                 [DebuggerNonUserCode]\r
3128                 public Supplier Supplier\r
3129                 {\r
3130                         get\r
3131                         {\r
3132                                 return _supplier.Entity;\r
3133                         }\r
3134                         set\r
3135                         {\r
3136                                 if (value != _supplier.Entity)\r
3137                                 {\r
3138                                         if (_supplier.Entity != null)\r
3139                                         {\r
3140                                                 var previousSupplier = _supplier.Entity;\r
3141                                                 _supplier.Entity = null;\r
3142                                                 previousSupplier.Products.Remove(this);\r
3143                                         }\r
3144                                         _supplier.Entity = value;\r
3145                                         if (value != null)\r
3146                                         {\r
3147                                                 value.Products.Add(this);\r
3148                                                 _supplierID = value.SupplierID;\r
3149                                         }\r
3150                                         else\r
3151                                         {\r
3152                                                 _supplierID = null;\r
3153                                         }\r
3154                                 }\r
3155                         }\r
3156                 }\r
3157 \r
3158                 private EntityRef<Category> _category;\r
3159                 [Association(Storage = "_category", OtherKey = "CategoryID", ThisKey = "CategoryID", Name = "fk_Products_1", IsForeignKey = true)]\r
3160                 [DebuggerNonUserCode]\r
3161                 public Category Category\r
3162                 {\r
3163                         get\r
3164                         {\r
3165                                 return _category.Entity;\r
3166                         }\r
3167                         set\r
3168                         {\r
3169                                 if (value != _category.Entity)\r
3170                                 {\r
3171                                         if (_category.Entity != null)\r
3172                                         {\r
3173                                                 var previousCategory = _category.Entity;\r
3174                                                 _category.Entity = null;\r
3175                                                 previousCategory.Products.Remove(this);\r
3176                                         }\r
3177                                         _category.Entity = value;\r
3178                                         if (value != null)\r
3179                                         {\r
3180                                                 value.Products.Add(this);\r
3181                                                 _categoryID = value.CategoryID;\r
3182                                         }\r
3183                                         else\r
3184                                         {\r
3185                                                 _categoryID = null;\r
3186                                         }\r
3187                                 }\r
3188                         }\r
3189                 }\r
3190 \r
3191 \r
3192                 #endregion\r
3193 \r
3194                 #region Attachement handlers\r
3195 \r
3196                 private void OrderDetails_Attach(OrderDetail entity)\r
3197                 {\r
3198                         entity.Product = this;\r
3199                 }\r
3200 \r
3201                 private void OrderDetails_Detach(OrderDetail entity)\r
3202                 {\r
3203                         entity.Product = null;\r
3204                 }\r
3205 \r
3206 \r
3207                 #endregion\r
3208 \r
3209                 #region ctor\r
3210 \r
3211                 public Product()\r
3212                 {\r
3213                         _orderDetails = new EntitySet<OrderDetail>(OrderDetails_Attach, OrderDetails_Detach);\r
3214                         _supplier = new EntityRef<Supplier>();\r
3215                         _category = new EntityRef<Category>();\r
3216                         OnCreated();\r
3217                 }\r
3218 \r
3219                 #endregion\r
3220 \r
3221         }\r
3222 \r
3223         [Table(Name = "main.Region")]\r
3224         public partial class Region : INotifyPropertyChanging, INotifyPropertyChanged\r
3225         {\r
3226                 #region INotifyPropertyChanging handling\r
3227 \r
3228                 public event PropertyChangingEventHandler PropertyChanging;\r
3229 \r
3230                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
3231                 protected virtual void SendPropertyChanging()\r
3232                 {\r
3233                         if (PropertyChanging != null)\r
3234                         {\r
3235                                 PropertyChanging(this, emptyChangingEventArgs);\r
3236                         }\r
3237                 }\r
3238 \r
3239                 #endregion\r
3240 \r
3241                 #region INotifyPropertyChanged handling\r
3242 \r
3243                 public event PropertyChangedEventHandler PropertyChanged;\r
3244 \r
3245                 protected virtual void SendPropertyChanged(string propertyName)\r
3246                 {\r
3247                         if (PropertyChanged != null)\r
3248                         {\r
3249                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
3250                         }\r
3251                 }\r
3252 \r
3253                 #endregion\r
3254 \r
3255                 #region Extensibility Method Definitions\r
3256 \r
3257                 partial void OnCreated();\r
3258                 partial void OnRegionDescriptionChanged();\r
3259                 partial void OnRegionDescriptionChanging(string value);\r
3260                 partial void OnRegionIDChanged();\r
3261                 partial void OnRegionIDChanging(int value);\r
3262 \r
3263                 #endregion\r
3264 \r
3265                 #region string RegionDescription\r
3266 \r
3267                 private string _regionDescription;\r
3268                 [DebuggerNonUserCode]\r
3269                 [Column(Storage = "_regionDescription", Name = "RegionDescription", DbType = "nchar", AutoSync = AutoSync.Never, CanBeNull = false)]\r
3270                 public string RegionDescription\r
3271                 {\r
3272                         get\r
3273                         {\r
3274                                 return _regionDescription;\r
3275                         }\r
3276                         set\r
3277                         {\r
3278                                 if (value != _regionDescription)\r
3279                                 {\r
3280                                         OnRegionDescriptionChanging(value);\r
3281                                         SendPropertyChanging();\r
3282                                         _regionDescription = value;\r
3283                                         SendPropertyChanged("RegionDescription");\r
3284                                         OnRegionDescriptionChanged();\r
3285                                 }\r
3286                         }\r
3287                 }\r
3288 \r
3289                 #endregion\r
3290 \r
3291                 #region int RegionID\r
3292 \r
3293                 private int _regionID;\r
3294                 [DebuggerNonUserCode]\r
3295                 [Column(Storage = "_regionID", Name = "RegionID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
3296                 public int RegionID\r
3297                 {\r
3298                         get\r
3299                         {\r
3300                                 return _regionID;\r
3301                         }\r
3302                         set\r
3303                         {\r
3304                                 if (value != _regionID)\r
3305                                 {\r
3306                                         OnRegionIDChanging(value);\r
3307                                         SendPropertyChanging();\r
3308                                         _regionID = value;\r
3309                                         SendPropertyChanged("RegionID");\r
3310                                         OnRegionIDChanged();\r
3311                                 }\r
3312                         }\r
3313                 }\r
3314 \r
3315                 #endregion\r
3316 \r
3317                 #region Children\r
3318 \r
3319                 private EntitySet<Territory> _territories;\r
3320                 [Association(Storage = "_territories", OtherKey = "RegionID", ThisKey = "RegionID", Name = "fk_Territories_0")]\r
3321                 [DebuggerNonUserCode]\r
3322                 public EntitySet<Territory> Territories\r
3323                 {\r
3324                         get\r
3325                         {\r
3326                                 return _territories;\r
3327                         }\r
3328                         set\r
3329                         {\r
3330                                 _territories = value;\r
3331                         }\r
3332                 }\r
3333 \r
3334 \r
3335                 #endregion\r
3336 \r
3337                 #region Attachement handlers\r
3338 \r
3339                 private void Territories_Attach(Territory entity)\r
3340                 {\r
3341                         entity.Region = this;\r
3342                 }\r
3343 \r
3344                 private void Territories_Detach(Territory entity)\r
3345                 {\r
3346                         entity.Region = null;\r
3347                 }\r
3348 \r
3349 \r
3350                 #endregion\r
3351 \r
3352                 #region ctor\r
3353 \r
3354                 public Region()\r
3355                 {\r
3356                         _territories = new EntitySet<Territory>(Territories_Attach, Territories_Detach);\r
3357                         OnCreated();\r
3358                 }\r
3359 \r
3360                 #endregion\r
3361 \r
3362         }\r
3363 \r
3364         [Table(Name = "main.Shippers")]\r
3365         public partial class Shipper : INotifyPropertyChanging, INotifyPropertyChanged\r
3366         {\r
3367                 #region INotifyPropertyChanging handling\r
3368 \r
3369                 public event PropertyChangingEventHandler PropertyChanging;\r
3370 \r
3371                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
3372                 protected virtual void SendPropertyChanging()\r
3373                 {\r
3374                         if (PropertyChanging != null)\r
3375                         {\r
3376                                 PropertyChanging(this, emptyChangingEventArgs);\r
3377                         }\r
3378                 }\r
3379 \r
3380                 #endregion\r
3381 \r
3382                 #region INotifyPropertyChanged handling\r
3383 \r
3384                 public event PropertyChangedEventHandler PropertyChanged;\r
3385 \r
3386                 protected virtual void SendPropertyChanged(string propertyName)\r
3387                 {\r
3388                         if (PropertyChanged != null)\r
3389                         {\r
3390                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
3391                         }\r
3392                 }\r
3393 \r
3394                 #endregion\r
3395 \r
3396                 #region Extensibility Method Definitions\r
3397 \r
3398                 partial void OnCreated();\r
3399                 partial void OnCompanyNameChanged();\r
3400                 partial void OnCompanyNameChanging(string value);\r
3401                 partial void OnPhoneChanged();\r
3402                 partial void OnPhoneChanging(string value);\r
3403                 partial void OnShipperIDChanged();\r
3404                 partial void OnShipperIDChanging(int value);\r
3405 \r
3406                 #endregion\r
3407 \r
3408                 #region string CompanyName\r
3409 \r
3410                 private string _companyName;\r
3411                 [DebuggerNonUserCode]\r
3412                 [Column(Storage = "_companyName", Name = "CompanyName", DbType = "nvarchar (40)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
3413                 public string CompanyName\r
3414                 {\r
3415                         get\r
3416                         {\r
3417                                 return _companyName;\r
3418                         }\r
3419                         set\r
3420                         {\r
3421                                 if (value != _companyName)\r
3422                                 {\r
3423                                         OnCompanyNameChanging(value);\r
3424                                         SendPropertyChanging();\r
3425                                         _companyName = value;\r
3426                                         SendPropertyChanged("CompanyName");\r
3427                                         OnCompanyNameChanged();\r
3428                                 }\r
3429                         }\r
3430                 }\r
3431 \r
3432                 #endregion\r
3433 \r
3434                 #region string Phone\r
3435 \r
3436                 private string _phone;\r
3437                 [DebuggerNonUserCode]\r
3438                 [Column(Storage = "_phone", Name = "Phone", DbType = "nvarchar (24)", AutoSync = AutoSync.Never)]\r
3439                 public string Phone\r
3440                 {\r
3441                         get\r
3442                         {\r
3443                                 return _phone;\r
3444                         }\r
3445                         set\r
3446                         {\r
3447                                 if (value != _phone)\r
3448                                 {\r
3449                                         OnPhoneChanging(value);\r
3450                                         SendPropertyChanging();\r
3451                                         _phone = value;\r
3452                                         SendPropertyChanged("Phone");\r
3453                                         OnPhoneChanged();\r
3454                                 }\r
3455                         }\r
3456                 }\r
3457 \r
3458                 #endregion\r
3459 \r
3460                 #region int ShipperID\r
3461 \r
3462                 private int _shipperID;\r
3463                 [DebuggerNonUserCode]\r
3464                 [Column(Storage = "_shipperID", Name = "ShipperID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
3465                 public int ShipperID\r
3466                 {\r
3467                         get\r
3468                         {\r
3469                                 return _shipperID;\r
3470                         }\r
3471                         set\r
3472                         {\r
3473                                 if (value != _shipperID)\r
3474                                 {\r
3475                                         OnShipperIDChanging(value);\r
3476                                         SendPropertyChanging();\r
3477                                         _shipperID = value;\r
3478                                         SendPropertyChanged("ShipperID");\r
3479                                         OnShipperIDChanged();\r
3480                                 }\r
3481                         }\r
3482                 }\r
3483 \r
3484                 #endregion\r
3485 \r
3486                 #region Children\r
3487 \r
3488                 private EntitySet<Order> _orders;\r
3489                 [Association(Storage = "_orders", OtherKey = "ShipVia", ThisKey = "ShipperID", Name = "fk_Orders_0")]\r
3490                 [DebuggerNonUserCode]\r
3491                 public EntitySet<Order> Orders\r
3492                 {\r
3493                         get\r
3494                         {\r
3495                                 return _orders;\r
3496                         }\r
3497                         set\r
3498                         {\r
3499                                 _orders = value;\r
3500                         }\r
3501                 }\r
3502 \r
3503 \r
3504                 #endregion\r
3505 \r
3506                 #region Attachement handlers\r
3507 \r
3508                 private void Orders_Attach(Order entity)\r
3509                 {\r
3510                         entity.Shipper = this;\r
3511                 }\r
3512 \r
3513                 private void Orders_Detach(Order entity)\r
3514                 {\r
3515                         entity.Shipper = null;\r
3516                 }\r
3517 \r
3518 \r
3519                 #endregion\r
3520 \r
3521                 #region ctor\r
3522 \r
3523                 public Shipper()\r
3524                 {\r
3525                         _orders = new EntitySet<Order>(Orders_Attach, Orders_Detach);\r
3526                         OnCreated();\r
3527                 }\r
3528 \r
3529                 #endregion\r
3530 \r
3531         }\r
3532 \r
3533         [Table(Name = "main.Suppliers")]\r
3534         public partial class Supplier : INotifyPropertyChanging, INotifyPropertyChanged\r
3535         {\r
3536                 #region INotifyPropertyChanging handling\r
3537 \r
3538                 public event PropertyChangingEventHandler PropertyChanging;\r
3539 \r
3540                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
3541                 protected virtual void SendPropertyChanging()\r
3542                 {\r
3543                         if (PropertyChanging != null)\r
3544                         {\r
3545                                 PropertyChanging(this, emptyChangingEventArgs);\r
3546                         }\r
3547                 }\r
3548 \r
3549                 #endregion\r
3550 \r
3551                 #region INotifyPropertyChanged handling\r
3552 \r
3553                 public event PropertyChangedEventHandler PropertyChanged;\r
3554 \r
3555                 protected virtual void SendPropertyChanged(string propertyName)\r
3556                 {\r
3557                         if (PropertyChanged != null)\r
3558                         {\r
3559                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
3560                         }\r
3561                 }\r
3562 \r
3563                 #endregion\r
3564 \r
3565                 #region Extensibility Method Definitions\r
3566 \r
3567                 partial void OnCreated();\r
3568                 partial void OnAddressChanged();\r
3569                 partial void OnAddressChanging(string value);\r
3570                 partial void OnCityChanged();\r
3571                 partial void OnCityChanging(string value);\r
3572                 partial void OnCompanyNameChanged();\r
3573                 partial void OnCompanyNameChanging(string value);\r
3574                 partial void OnContactNameChanged();\r
3575                 partial void OnContactNameChanging(string value);\r
3576                 partial void OnContactTitleChanged();\r
3577                 partial void OnContactTitleChanging(string value);\r
3578                 partial void OnCountryChanged();\r
3579                 partial void OnCountryChanging(string value);\r
3580                 partial void OnFaxChanged();\r
3581                 partial void OnFaxChanging(string value);\r
3582                 partial void OnHomePageChanged();\r
3583                 partial void OnHomePageChanging(string value);\r
3584                 partial void OnPhoneChanged();\r
3585                 partial void OnPhoneChanging(string value);\r
3586                 partial void OnPostalCodeChanged();\r
3587                 partial void OnPostalCodeChanging(string value);\r
3588                 partial void OnRegionChanged();\r
3589                 partial void OnRegionChanging(string value);\r
3590                 partial void OnSupplierIDChanged();\r
3591                 partial void OnSupplierIDChanging(int value);\r
3592 \r
3593                 #endregion\r
3594 \r
3595                 #region string Address\r
3596 \r
3597                 private string _address;\r
3598                 [DebuggerNonUserCode]\r
3599                 [Column(Storage = "_address", Name = "Address", DbType = "nvarchar (60)", AutoSync = AutoSync.Never)]\r
3600                 public string Address\r
3601                 {\r
3602                         get\r
3603                         {\r
3604                                 return _address;\r
3605                         }\r
3606                         set\r
3607                         {\r
3608                                 if (value != _address)\r
3609                                 {\r
3610                                         OnAddressChanging(value);\r
3611                                         SendPropertyChanging();\r
3612                                         _address = value;\r
3613                                         SendPropertyChanged("Address");\r
3614                                         OnAddressChanged();\r
3615                                 }\r
3616                         }\r
3617                 }\r
3618 \r
3619                 #endregion\r
3620 \r
3621                 #region string City\r
3622 \r
3623                 private string _city;\r
3624                 [DebuggerNonUserCode]\r
3625                 [Column(Storage = "_city", Name = "City", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
3626                 public string City\r
3627                 {\r
3628                         get\r
3629                         {\r
3630                                 return _city;\r
3631                         }\r
3632                         set\r
3633                         {\r
3634                                 if (value != _city)\r
3635                                 {\r
3636                                         OnCityChanging(value);\r
3637                                         SendPropertyChanging();\r
3638                                         _city = value;\r
3639                                         SendPropertyChanged("City");\r
3640                                         OnCityChanged();\r
3641                                 }\r
3642                         }\r
3643                 }\r
3644 \r
3645                 #endregion\r
3646 \r
3647                 #region string CompanyName\r
3648 \r
3649                 private string _companyName;\r
3650                 [DebuggerNonUserCode]\r
3651                 [Column(Storage = "_companyName", Name = "CompanyName", DbType = "nvarchar (40)", AutoSync = AutoSync.Never, CanBeNull = false)]\r
3652                 public string CompanyName\r
3653                 {\r
3654                         get\r
3655                         {\r
3656                                 return _companyName;\r
3657                         }\r
3658                         set\r
3659                         {\r
3660                                 if (value != _companyName)\r
3661                                 {\r
3662                                         OnCompanyNameChanging(value);\r
3663                                         SendPropertyChanging();\r
3664                                         _companyName = value;\r
3665                                         SendPropertyChanged("CompanyName");\r
3666                                         OnCompanyNameChanged();\r
3667                                 }\r
3668                         }\r
3669                 }\r
3670 \r
3671                 #endregion\r
3672 \r
3673                 #region string ContactName\r
3674 \r
3675                 private string _contactName;\r
3676                 [DebuggerNonUserCode]\r
3677                 [Column(Storage = "_contactName", Name = "ContactName", DbType = "nvarchar (30)", AutoSync = AutoSync.Never)]\r
3678                 public string ContactName\r
3679                 {\r
3680                         get\r
3681                         {\r
3682                                 return _contactName;\r
3683                         }\r
3684                         set\r
3685                         {\r
3686                                 if (value != _contactName)\r
3687                                 {\r
3688                                         OnContactNameChanging(value);\r
3689                                         SendPropertyChanging();\r
3690                                         _contactName = value;\r
3691                                         SendPropertyChanged("ContactName");\r
3692                                         OnContactNameChanged();\r
3693                                 }\r
3694                         }\r
3695                 }\r
3696 \r
3697                 #endregion\r
3698 \r
3699                 #region string ContactTitle\r
3700 \r
3701                 private string _contactTitle;\r
3702                 [DebuggerNonUserCode]\r
3703                 [Column(Storage = "_contactTitle", Name = "ContactTitle", DbType = "nvarchar (30)", AutoSync = AutoSync.Never)]\r
3704                 public string ContactTitle\r
3705                 {\r
3706                         get\r
3707                         {\r
3708                                 return _contactTitle;\r
3709                         }\r
3710                         set\r
3711                         {\r
3712                                 if (value != _contactTitle)\r
3713                                 {\r
3714                                         OnContactTitleChanging(value);\r
3715                                         SendPropertyChanging();\r
3716                                         _contactTitle = value;\r
3717                                         SendPropertyChanged("ContactTitle");\r
3718                                         OnContactTitleChanged();\r
3719                                 }\r
3720                         }\r
3721                 }\r
3722 \r
3723                 #endregion\r
3724 \r
3725                 #region string Country\r
3726 \r
3727                 private string _country;\r
3728                 [DebuggerNonUserCode]\r
3729                 [Column(Storage = "_country", Name = "Country", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
3730                 public string Country\r
3731                 {\r
3732                         get\r
3733                         {\r
3734                                 return _country;\r
3735                         }\r
3736                         set\r
3737                         {\r
3738                                 if (value != _country)\r
3739                                 {\r
3740                                         OnCountryChanging(value);\r
3741                                         SendPropertyChanging();\r
3742                                         _country = value;\r
3743                                         SendPropertyChanged("Country");\r
3744                                         OnCountryChanged();\r
3745                                 }\r
3746                         }\r
3747                 }\r
3748 \r
3749                 #endregion\r
3750 \r
3751                 #region string Fax\r
3752 \r
3753                 private string _fax;\r
3754                 [DebuggerNonUserCode]\r
3755                 [Column(Storage = "_fax", Name = "Fax", DbType = "nvarchar (24)", AutoSync = AutoSync.Never)]\r
3756                 public string Fax\r
3757                 {\r
3758                         get\r
3759                         {\r
3760                                 return _fax;\r
3761                         }\r
3762                         set\r
3763                         {\r
3764                                 if (value != _fax)\r
3765                                 {\r
3766                                         OnFaxChanging(value);\r
3767                                         SendPropertyChanging();\r
3768                                         _fax = value;\r
3769                                         SendPropertyChanged("Fax");\r
3770                                         OnFaxChanged();\r
3771                                 }\r
3772                         }\r
3773                 }\r
3774 \r
3775                 #endregion\r
3776 \r
3777                 #region string HomePage\r
3778 \r
3779                 private string _homePage;\r
3780                 [DebuggerNonUserCode]\r
3781                 [Column(Storage = "_homePage", Name = "HomePage", DbType = "ntext", AutoSync = AutoSync.Never)]\r
3782                 public string HomePage\r
3783                 {\r
3784                         get\r
3785                         {\r
3786                                 return _homePage;\r
3787                         }\r
3788                         set\r
3789                         {\r
3790                                 if (value != _homePage)\r
3791                                 {\r
3792                                         OnHomePageChanging(value);\r
3793                                         SendPropertyChanging();\r
3794                                         _homePage = value;\r
3795                                         SendPropertyChanged("HomePage");\r
3796                                         OnHomePageChanged();\r
3797                                 }\r
3798                         }\r
3799                 }\r
3800 \r
3801                 #endregion\r
3802 \r
3803                 #region string Phone\r
3804 \r
3805                 private string _phone;\r
3806                 [DebuggerNonUserCode]\r
3807                 [Column(Storage = "_phone", Name = "Phone", DbType = "nvarchar (24)", AutoSync = AutoSync.Never)]\r
3808                 public string Phone\r
3809                 {\r
3810                         get\r
3811                         {\r
3812                                 return _phone;\r
3813                         }\r
3814                         set\r
3815                         {\r
3816                                 if (value != _phone)\r
3817                                 {\r
3818                                         OnPhoneChanging(value);\r
3819                                         SendPropertyChanging();\r
3820                                         _phone = value;\r
3821                                         SendPropertyChanged("Phone");\r
3822                                         OnPhoneChanged();\r
3823                                 }\r
3824                         }\r
3825                 }\r
3826 \r
3827                 #endregion\r
3828 \r
3829                 #region string PostalCode\r
3830 \r
3831                 private string _postalCode;\r
3832                 [DebuggerNonUserCode]\r
3833                 [Column(Storage = "_postalCode", Name = "PostalCode", DbType = "nvarchar (10)", AutoSync = AutoSync.Never)]\r
3834                 public string PostalCode\r
3835                 {\r
3836                         get\r
3837                         {\r
3838                                 return _postalCode;\r
3839                         }\r
3840                         set\r
3841                         {\r
3842                                 if (value != _postalCode)\r
3843                                 {\r
3844                                         OnPostalCodeChanging(value);\r
3845                                         SendPropertyChanging();\r
3846                                         _postalCode = value;\r
3847                                         SendPropertyChanged("PostalCode");\r
3848                                         OnPostalCodeChanged();\r
3849                                 }\r
3850                         }\r
3851                 }\r
3852 \r
3853                 #endregion\r
3854 \r
3855                 #region string Region\r
3856 \r
3857                 private string _region;\r
3858                 [DebuggerNonUserCode]\r
3859                 [Column(Storage = "_region", Name = "Region", DbType = "nvarchar (15)", AutoSync = AutoSync.Never)]\r
3860                 public string Region\r
3861                 {\r
3862                         get\r
3863                         {\r
3864                                 return _region;\r
3865                         }\r
3866                         set\r
3867                         {\r
3868                                 if (value != _region)\r
3869                                 {\r
3870                                         OnRegionChanging(value);\r
3871                                         SendPropertyChanging();\r
3872                                         _region = value;\r
3873                                         SendPropertyChanged("Region");\r
3874                                         OnRegionChanged();\r
3875                                 }\r
3876                         }\r
3877                 }\r
3878 \r
3879                 #endregion\r
3880 \r
3881                 #region int SupplierID\r
3882 \r
3883                 private int _supplierID;\r
3884                 [DebuggerNonUserCode]\r
3885                 [Column(Storage = "_supplierID", Name = "SupplierID", DbType = "INTEGER", IsPrimaryKey = true, IsDbGenerated = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
3886                 public int SupplierID\r
3887                 {\r
3888                         get\r
3889                         {\r
3890                                 return _supplierID;\r
3891                         }\r
3892                         set\r
3893                         {\r
3894                                 if (value != _supplierID)\r
3895                                 {\r
3896                                         OnSupplierIDChanging(value);\r
3897                                         SendPropertyChanging();\r
3898                                         _supplierID = value;\r
3899                                         SendPropertyChanged("SupplierID");\r
3900                                         OnSupplierIDChanged();\r
3901                                 }\r
3902                         }\r
3903                 }\r
3904 \r
3905                 #endregion\r
3906 \r
3907                 #region Children\r
3908 \r
3909                 private EntitySet<Product> _products;\r
3910                 [Association(Storage = "_products", OtherKey = "SupplierID", ThisKey = "SupplierID", Name = "fk_Products_0")]\r
3911                 [DebuggerNonUserCode]\r
3912                 public EntitySet<Product> Products\r
3913                 {\r
3914                         get\r
3915                         {\r
3916                                 return _products;\r
3917                         }\r
3918                         set\r
3919                         {\r
3920                                 _products = value;\r
3921                         }\r
3922                 }\r
3923 \r
3924 \r
3925                 #endregion\r
3926 \r
3927                 #region Attachement handlers\r
3928 \r
3929                 private void Products_Attach(Product entity)\r
3930                 {\r
3931                         entity.Supplier = this;\r
3932                 }\r
3933 \r
3934                 private void Products_Detach(Product entity)\r
3935                 {\r
3936                         entity.Supplier = null;\r
3937                 }\r
3938 \r
3939 \r
3940                 #endregion\r
3941 \r
3942                 #region ctor\r
3943 \r
3944                 public Supplier()\r
3945                 {\r
3946                         _products = new EntitySet<Product>(Products_Attach, Products_Detach);\r
3947                         OnCreated();\r
3948                 }\r
3949 \r
3950                 #endregion\r
3951 \r
3952         }\r
3953 \r
3954         [Table(Name = "main.Territories")]\r
3955         public partial class Territory : INotifyPropertyChanging, INotifyPropertyChanged\r
3956         {\r
3957                 #region INotifyPropertyChanging handling\r
3958 \r
3959                 public event PropertyChangingEventHandler PropertyChanging;\r
3960 \r
3961                 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs("");\r
3962                 protected virtual void SendPropertyChanging()\r
3963                 {\r
3964                         if (PropertyChanging != null)\r
3965                         {\r
3966                                 PropertyChanging(this, emptyChangingEventArgs);\r
3967                         }\r
3968                 }\r
3969 \r
3970                 #endregion\r
3971 \r
3972                 #region INotifyPropertyChanged handling\r
3973 \r
3974                 public event PropertyChangedEventHandler PropertyChanged;\r
3975 \r
3976                 protected virtual void SendPropertyChanged(string propertyName)\r
3977                 {\r
3978                         if (PropertyChanged != null)\r
3979                         {\r
3980                                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));\r
3981                         }\r
3982                 }\r
3983 \r
3984                 #endregion\r
3985 \r
3986                 #region Extensibility Method Definitions\r
3987 \r
3988                 partial void OnCreated();\r
3989                 partial void OnRegionIDChanged();\r
3990                 partial void OnRegionIDChanging(int value);\r
3991                 partial void OnTerritoryDescriptionChanged();\r
3992                 partial void OnTerritoryDescriptionChanging(string value);\r
3993                 partial void OnTerritoryIDChanged();\r
3994                 partial void OnTerritoryIDChanging(string value);\r
3995 \r
3996                 #endregion\r
3997 \r
3998                 #region int RegionID\r
3999 \r
4000                 private int _regionID;\r
4001                 [DebuggerNonUserCode]\r
4002                 [Column(Storage = "_regionID", Name = "RegionID", DbType = "INTEGER", AutoSync = AutoSync.Never, CanBeNull = false)]\r
4003                 public int RegionID\r
4004                 {\r
4005                         get\r
4006                         {\r
4007                                 return _regionID;\r
4008                         }\r
4009                         set\r
4010                         {\r
4011                                 if (value != _regionID)\r
4012                                 {\r
4013                                         if (_region.HasLoadedOrAssignedValue)\r
4014                                         {\r
4015                                                 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();\r
4016                                         }\r
4017                                         OnRegionIDChanging(value);\r
4018                                         SendPropertyChanging();\r
4019                                         _regionID = value;\r
4020                                         SendPropertyChanged("RegionID");\r
4021                                         OnRegionIDChanged();\r
4022                                 }\r
4023                         }\r
4024                 }\r
4025 \r
4026                 #endregion\r
4027 \r
4028                 #region string TerritoryDescription\r
4029 \r
4030                 private string _territoryDescription;\r
4031                 [DebuggerNonUserCode]\r
4032                 [Column(Storage = "_territoryDescription", Name = "TerritoryDescription", DbType = "nchar", AutoSync = AutoSync.Never, CanBeNull = false)]\r
4033                 public string TerritoryDescription\r
4034                 {\r
4035                         get\r
4036                         {\r
4037                                 return _territoryDescription;\r
4038                         }\r
4039                         set\r
4040                         {\r
4041                                 if (value != _territoryDescription)\r
4042                                 {\r
4043                                         OnTerritoryDescriptionChanging(value);\r
4044                                         SendPropertyChanging();\r
4045                                         _territoryDescription = value;\r
4046                                         SendPropertyChanged("TerritoryDescription");\r
4047                                         OnTerritoryDescriptionChanged();\r
4048                                 }\r
4049                         }\r
4050                 }\r
4051 \r
4052                 #endregion\r
4053 \r
4054                 #region string TerritoryID\r
4055 \r
4056                 private string _territoryID;\r
4057                 [DebuggerNonUserCode]\r
4058                 [Column(Storage = "_territoryID", Name = "TerritoryID", DbType = "nvarchar", IsPrimaryKey = true, AutoSync = AutoSync.Never, CanBeNull = false)]\r
4059                 public string TerritoryID\r
4060                 {\r
4061                         get\r
4062                         {\r
4063                                 return _territoryID;\r
4064                         }\r
4065                         set\r
4066                         {\r
4067                                 if (value != _territoryID)\r
4068                                 {\r
4069                                         OnTerritoryIDChanging(value);\r
4070                                         SendPropertyChanging();\r
4071                                         _territoryID = value;\r
4072                                         SendPropertyChanged("TerritoryID");\r
4073                                         OnTerritoryIDChanged();\r
4074                                 }\r
4075                         }\r
4076                 }\r
4077 \r
4078                 #endregion\r
4079 \r
4080                 #region Children\r
4081 \r
4082                 private EntitySet<EmployeeTerritory> _employeeTerritories;\r
4083                 [Association(Storage = "_employeeTerritories", OtherKey = "TerritoryID", ThisKey = "TerritoryID", Name = "fk_EmployeeTerritories_0")]\r
4084                 [DebuggerNonUserCode]\r
4085                 public EntitySet<EmployeeTerritory> EmployeeTerritories\r
4086                 {\r
4087                         get\r
4088                         {\r
4089                                 return _employeeTerritories;\r
4090                         }\r
4091                         set\r
4092                         {\r
4093                                 _employeeTerritories = value;\r
4094                         }\r
4095                 }\r
4096 \r
4097 \r
4098                 #endregion\r
4099 \r
4100                 #region Parents\r
4101 \r
4102                 private EntityRef<Region> _region;\r
4103                 [Association(Storage = "_region", OtherKey = "RegionID", ThisKey = "RegionID", Name = "fk_Territories_0", IsForeignKey = true)]\r
4104                 [DebuggerNonUserCode]\r
4105                 public Region Region\r
4106                 {\r
4107                         get\r
4108                         {\r
4109                                 return _region.Entity;\r
4110                         }\r
4111                         set\r
4112                         {\r
4113                                 if (value != _region.Entity)\r
4114                                 {\r
4115                                         if (_region.Entity != null)\r
4116                                         {\r
4117                                                 var previousRegion = _region.Entity;\r
4118                                                 _region.Entity = null;\r
4119                                                 previousRegion.Territories.Remove(this);\r
4120                                         }\r
4121                                         _region.Entity = value;\r
4122                                         if (value != null)\r
4123                                         {\r
4124                                                 value.Territories.Add(this);\r
4125                                                 _regionID = value.RegionID;\r
4126                                         }\r
4127                                         else\r
4128                                         {\r
4129                                                 _regionID = default(int);\r
4130                                         }\r
4131                                 }\r
4132                         }\r
4133                 }\r
4134 \r
4135 \r
4136                 #endregion\r
4137 \r
4138                 #region Attachement handlers\r
4139 \r
4140                 private void EmployeeTerritories_Attach(EmployeeTerritory entity)\r
4141                 {\r
4142                         entity.Territory = this;\r
4143                 }\r
4144 \r
4145                 private void EmployeeTerritories_Detach(EmployeeTerritory entity)\r
4146                 {\r
4147                         entity.Territory = null;\r
4148                 }\r
4149 \r
4150 \r
4151                 #endregion\r
4152 \r
4153                 #region ctor\r
4154 \r
4155                 public Territory()\r
4156                 {\r
4157                         _employeeTerritories = new EntitySet<EmployeeTerritory>(EmployeeTerritories_Attach, EmployeeTerritories_Detach);\r
4158                         _region = new EntityRef<Region>();\r
4159                         OnCreated();\r
4160                 }\r
4161 \r
4162                 #endregion\r
4163 \r
4164         }\r
4165 }\r