关于这个.dbml文件,我们只要在拖一张表,就可以自动 生成一些代码
好像这些代码包含了, 一些增删改等的语句。但是小弟不知怎样用。
要想用里面的代码。就得要看得懂这个.dbml的CS文件到底是怎样一回事。
例如:插入记录:
在那里呀。到底下面的这些语句是怎样用的?小弟一点也不明?
恳请高手帮帮小弟。小弟无尽感激。谢谢您们。#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
// 此代码由工具生成。
// 运行时版本:2.0.50727.4200
//
// 对此文件的更改可能会导致不正确的行为,并且如果
// 重新生成代码,这些更改将会丢失。
// </auto-generated>
//------------------------------------------------------------------------------namespace MVC_Demo
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="MyFileDB")]
public partial class MyFileDBDataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Extensibility Method Definitions
partial void OnCreated();
partial void InsertMyFiles(MyFiles instance);
partial void UpdateMyFiles(MyFiles instance);
partial void DeleteMyFiles(MyFiles instance);
#endregion
public MyFileDBDataContext() :
base(global::System.Configuration.ConfigurationManager.ConnectionStrings["MyFileDBConnectionString"].ConnectionString, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table<MyFiles> MyFiles
{
get
{
return this.GetTable<MyFiles>();
}
}
}
[Table(Name="dbo.MyFiles")]
public partial class MyFiles : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _FileID;
private string _FileName;
private string _FileType;
private System.Data.Linq.Binary _FileData;
private System.DateTime _FileUpDate;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnFileIDChanging(int value);
partial void OnFileIDChanged();
partial void OnFileNameChanging(string value);
partial void OnFileNameChanged();
partial void OnFileTypeChanging(string value);
partial void OnFileTypeChanged();
partial void OnFileDataChanging(System.Data.Linq.Binary value);
partial void OnFileDataChanged();
partial void OnFileUpDateChanging(System.DateTime value);
partial void OnFileUpDateChanged();
#endregion
public MyFiles()
{
OnCreated();
}
[Column(Storage="_FileID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int FileID
{
get
{
return this._FileID;
}
set
{
if ((this._FileID != value))
{
this.OnFileIDChanging(value);
this.SendPropertyChanging();
this._FileID = value;
this.SendPropertyChanged("FileID");
this.OnFileIDChanged();
}
}
}
[Column(Storage="_FileName", DbType="NChar(50) NOT NULL", CanBeNull=false)]
public string FileName
{
get
{
return this._FileName;
}
set
{
if ((this._FileName != value))
{
this.OnFileNameChanging(value);
this.SendPropertyChanging();
this._FileName = value;
this.SendPropertyChanged("FileName");
this.OnFileNameChanged();
}
}
}
[Column(Storage="_FileType", DbType="NChar(50) NOT NULL", CanBeNull=false)]
public string FileType
{
get
{
return this._FileType;
}
set
{
if ((this._FileType != value))
{
this.OnFileTypeChanging(value);
this.SendPropertyChanging();
this._FileType = value;
this.SendPropertyChanged("FileType");
this.OnFileTypeChanged();
}
}
}
[Column(Storage="_FileData", DbType="Image NOT NULL", CanBeNull=false, UpdateCheck=UpdateCheck.Never)]
public System.Data.Linq.Binary FileData
{
get
{
return this._FileData;
}
set
{
if ((this._FileData != value))
{
this.OnFileDataChanging(value);
this.SendPropertyChanging();
this._FileData = value;
this.SendPropertyChanged("FileData");
this.OnFileDataChanged();
}
}
}
[Column(Storage="_FileUpDate", DbType="DateTime NOT NULL")]
public System.DateTime FileUpDate
{
get
{
return this._FileUpDate;
}
set
{
if ((this._FileUpDate != value))
{
this.OnFileUpDateChanging(value);
this.SendPropertyChanging();
this._FileUpDate = value;
this.SendPropertyChanged("FileUpDate");
this.OnFileUpDateChanged();
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
}
#pragma warning restore 1591
好像这些代码包含了, 一些增删改等的语句。但是小弟不知怎样用。
要想用里面的代码。就得要看得懂这个.dbml的CS文件到底是怎样一回事。
例如:插入记录:
在那里呀。到底下面的这些语句是怎样用的?小弟一点也不明?
恳请高手帮帮小弟。小弟无尽感激。谢谢您们。#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
// 此代码由工具生成。
// 运行时版本:2.0.50727.4200
//
// 对此文件的更改可能会导致不正确的行为,并且如果
// 重新生成代码,这些更改将会丢失。
// </auto-generated>
//------------------------------------------------------------------------------namespace MVC_Demo
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="MyFileDB")]
public partial class MyFileDBDataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Extensibility Method Definitions
partial void OnCreated();
partial void InsertMyFiles(MyFiles instance);
partial void UpdateMyFiles(MyFiles instance);
partial void DeleteMyFiles(MyFiles instance);
#endregion
public MyFileDBDataContext() :
base(global::System.Configuration.ConfigurationManager.ConnectionStrings["MyFileDBConnectionString"].ConnectionString, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public MyFileDBDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table<MyFiles> MyFiles
{
get
{
return this.GetTable<MyFiles>();
}
}
}
[Table(Name="dbo.MyFiles")]
public partial class MyFiles : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _FileID;
private string _FileName;
private string _FileType;
private System.Data.Linq.Binary _FileData;
private System.DateTime _FileUpDate;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnFileIDChanging(int value);
partial void OnFileIDChanged();
partial void OnFileNameChanging(string value);
partial void OnFileNameChanged();
partial void OnFileTypeChanging(string value);
partial void OnFileTypeChanged();
partial void OnFileDataChanging(System.Data.Linq.Binary value);
partial void OnFileDataChanged();
partial void OnFileUpDateChanging(System.DateTime value);
partial void OnFileUpDateChanged();
#endregion
public MyFiles()
{
OnCreated();
}
[Column(Storage="_FileID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int FileID
{
get
{
return this._FileID;
}
set
{
if ((this._FileID != value))
{
this.OnFileIDChanging(value);
this.SendPropertyChanging();
this._FileID = value;
this.SendPropertyChanged("FileID");
this.OnFileIDChanged();
}
}
}
[Column(Storage="_FileName", DbType="NChar(50) NOT NULL", CanBeNull=false)]
public string FileName
{
get
{
return this._FileName;
}
set
{
if ((this._FileName != value))
{
this.OnFileNameChanging(value);
this.SendPropertyChanging();
this._FileName = value;
this.SendPropertyChanged("FileName");
this.OnFileNameChanged();
}
}
}
[Column(Storage="_FileType", DbType="NChar(50) NOT NULL", CanBeNull=false)]
public string FileType
{
get
{
return this._FileType;
}
set
{
if ((this._FileType != value))
{
this.OnFileTypeChanging(value);
this.SendPropertyChanging();
this._FileType = value;
this.SendPropertyChanged("FileType");
this.OnFileTypeChanged();
}
}
}
[Column(Storage="_FileData", DbType="Image NOT NULL", CanBeNull=false, UpdateCheck=UpdateCheck.Never)]
public System.Data.Linq.Binary FileData
{
get
{
return this._FileData;
}
set
{
if ((this._FileData != value))
{
this.OnFileDataChanging(value);
this.SendPropertyChanging();
this._FileData = value;
this.SendPropertyChanged("FileData");
this.OnFileDataChanged();
}
}
}
[Column(Storage="_FileUpDate", DbType="DateTime NOT NULL")]
public System.DateTime FileUpDate
{
get
{
return this._FileUpDate;
}
set
{
if ((this._FileUpDate != value))
{
this.OnFileUpDateChanging(value);
this.SendPropertyChanging();
this._FileUpDate = value;
this.SendPropertyChanged("FileUpDate");
this.OnFileUpDateChanged();
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
}
#pragma warning restore 1591
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货