基于LINQ to SQL的WEB开发三层架构Word文件下载.docx
《基于LINQ to SQL的WEB开发三层架构Word文件下载.docx》由会员分享,可在线阅读,更多相关《基于LINQ to SQL的WEB开发三层架构Word文件下载.docx(25页珍藏版)》请在冰豆网上搜索。
![基于LINQ to SQL的WEB开发三层架构Word文件下载.docx](https://file1.bdocx.com/fileroot1/2022-10/29/767d08a6-a103-4974-becf-7b5890e11a74/767d08a6-a103-4974-becf-7b5890e11a741.gif)
#pragmawarningdisable1591
//--------------------------------------
----------------------------------------
//
//此代码由
工具生成。
//运行时版本:
2.0.50727.3053
//
//对此文件的更改可能会
导致不正确的行为,并且如果
//重新生成代码,这些更改将会丢失。
//-----------------------------------------------------------------
-------------
namespaceDAL
{
usingSystem.Data.Linq;
using
System.Data.Linq.Mapping;
usingSystem.Data;
System.Collections.Generic;
usingSystem.Reflection;
System.Linq;
usingSystem.Linq.Expressions;
System.ComponentModel;
usingSystem;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="
Northwind"
)]
public
partialclassNorthwindDataContext:
System.Data.Linq.DataContext
privatestaticSystem.Data.Linq.Mapping.MappingSourcemappingSource=new
AttributeMappingSource();
#regionExtensibilityMethodDefinitions
partialvoidOnCreated();
partialvoidInsertEmployees(Employees
instance);
partialvoidUpdateEmployees(Employeesinstance);
partial
voidDeleteEmployees(Employeesinstance);
#endregion
NorthwindDataContext():
base
(global:
:
DAL.Properties.Settings.Default.NorthwindConnectionString,mappingSource)
OnCreated();
}
publicNorthwindDataContext(string
connection):
base(connection,mappingSource)
publicNorthwindDataContext(System.Data.IDbConnectionconnection):
publicNorthwindDataContext(stringconnection,
System.Data.Linq.Mapping.MappingSourcemappingSource):
base(connection,
mappingSource)
NorthwindDataContext(System.Data.IDbConnectionconnection,
System.Data.Linq.TableEmployees
get
return
this.GetTable();
[Table
(Name="
dbo.Employees"
publicpartialclassEmployees:
INotifyPropertyChanging,INotifyPropertyChanged
privatestatic
PropertyChangingEventArgsemptyChangingEventArgs=newPropertyChangingEventArgs
(String.Empty);
privateint_EmployeeID;
privatestring
_LastName;
privatestring_FirstName;
_Title;
privatestring_TitleOfCourtesy;
private
System.Nullable_BirthDate;
System.Nullable_HireDate;
privatestring_Address;
privatestring_City;
privatestring_Region;
string_PostalCode;
privatestring_Country;
_HomePhone;
privatestring_Extension;
System.Data.Linq.Binary_Photo;
privatestring_Notes;
privateSystem.Nullable_ReportsTo;
privatestring_PhotoPath;
partialvoidOnLoaded
();
partialvoidOnValidate(System.Data.Linq.ChangeActionaction);
partialvoidOnEmployeeIDChanging(intvalue);
partialvoidOnEmployeeIDChanged();
partialvoidOnLastNameChanging(string
value);
partialvoidOnLastNameChanged();
partialvoid
OnFirstNameChanging(stringvalue);
partialvoidOnFirstNameChanged();
partialvoidOnTitleChanging(stringvalue);
partialvoidOnTitleChanged
partialvoidOnTitleOfCourtesyChanging(stringvalue);
voidOnTitleOfCourtesyChanged();
partialvoidOnBirthDateChanging
(System.Nullablevalue);
partialvoidOnBirthDateChanged
partialvoidOnHireDateChanging(System.Nullable
partialvoidOnHireDateChanged();
OnAddressChanging(stringvalue);
partialvoidOnAddressChanged();
partialvoidOnCityChanging(stringvalue);
partialvoidOnCityChanged();
partialvoidOnRegionChanging(stringvalue);
OnRegionChanged();
partialvoidOnPostalCodeChanging(stringvalue);
partialvoidOnPostalCodeChanged();
partialvoidOnCountryChanging(string
partialvoidOnCountryChanged();
OnHomePhoneChanging(stringvalue);
partialvoidOnHomePhoneChanged();
partialvoidOnExtensionChanging(stringvalue);
OnExtensionChanged();
partialvoidOnPhotoChanging(System.Data.Linq.Binary
partialvoidO