一.SQLServer数据库创建表Company,包含ID,CName,IsEnabled三列
二.(1)VS新建一个DXApplication工程,名为CompanyManageSystem
(2)在工程下,右键点击“引用” -> "管理NuGet程序包" -> "浏览" -> 找到"EntityFramework" -> 点击“安装”
(3)新建一个类PSContext.cs
namespaceCompanyManageSystem
{
classPSContext : DbContext
{
public PSContext() : base("name=PSContext"){}
public virtual DbSet Companys { get; set; }
protected override voidOnModelCreating(DbModelBuilder modelBuilder)
{
}
}
}
(4)新建一个类Company.cs
namespaceCompanyManageSystem.Model
{
[Table("Company")]
public classCompany
{
public Guid ID { get; set; }
public String CName { get; set; }
public bool IsEnabled { get; set; }
}
}
(5)在App.config添加数据库的代码
(6)添加窗体Frm_ShowInfo.cs (注意:FiledName里面的名字要和数据库的列名相同,(Name)里面的名字尽量不取Name)
添加控件如图所示:
namespaceCompanyManageSystem
{public partial classFrm_ShowInfo : Form
{
PSContext _db= newPSContext();publicFrm_ShowInfo()
{
InitializeComponent();
}private void Frm_ShowInfo_Load(objectsender, EventArgs e)
{
CompanyGrid.DataSource=_db.Companys.AsNoTracking().ToList();
}
}
}
(7)在Program.cs启动Frm_ShowInfo.cs窗口
namespaceCompanyManageSystem
{static classProgram
{///
///The main entry point for the application.///
[STAThread]static voidMain()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
BonusSkins.Register();
SkinManager.EnableFormSkins();
UserLookAndFeel.Default.SetSkinStyle("DevExpress Style");
Application.Run(newFrm_ShowInfo());
}
}
}
实体加载MySQL数据库
1.需要在“管理NuGet程序包”里面安装装“MySql.Data”和“MySql.Data.Entity”2.配置App.config文件
3.其余部分和SQLServer一样
延伸知识(本地数据库或其它服务器)