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