mysql 不能用dbcontext_使用DbContext实体类访问数据库

首先要把 EFCodeFirst类库工程里，添加EntityFramework的引用。

///

/// FileInfo:实体类名要和数据表名的名称一样。

///

[Serializable]

public partial class t_FileInfo

{

public t_FileInfo()

{}

#region Model

private int _id;

private string _fileulr;

private DateTime _uploadtime;

private int _infotype;

private int _userid;

///

///

///

public int ID

{

set{ _id=value;}

get{return _id;}

}

///

///

///

public string FileUlr

{

set{ _fileulr=value;}

get{return _fileulr;}

}

///

///

///

public DateTime UploadTime

{

set{ _uploadtime=value;}

get{return _uploadtime;}

}

///

///

///

public int InfoType

{

set{ _infotype=value;}

get{return _infotype;}

}

///

///

///

public int UserID

{

set{ _userid=value;}

get{return _userid;}

}

#endregion Model

}

public class t_FileInfoDB : DbContext

{

public t_FileInfoDB()

: base("ApplicationServices")

{

}

public DbSet FileInfo { get; set; }

}

ApplicationServices是配置节点里边的name

connectionString="Data Source=.\SQL2005;Initial Catalog=CrmSystemDB;Integrated Security=True"

providerName="System.Data.SqlClient" />

使用：

t_FileInfoDB db = new t_FileInfoDB();

var tb = from d in db.FileInfo where d.ID >=0 select d;

return tb.ToList();