C#------EntityFramework實體載入資料庫

標籤：

一.SQLServer資料庫建立表Company，包含ID，CName，IsEnabled三列

二.(1)VS建立一個DXApplication工程，名為CompanyManageSystem

    (2)在工程下，右鍵點擊“引用” -> "管理NuGet程式包" -> "瀏覽" -> 找到"EntityFramework" -> 點擊“安裝”

    (3)建立一個類PSContext.cs

namespace CompanyManageSystem{    class PSContext : DbContext    {        public PSContext() : base("name=PSContext"){}        public virtual DbSet<Company> Companys { get; set; }        protected override void OnModelCreating(DbModelBuilder modelBuilder)        {        }    }}

     (4)建立一個類Company.cs

namespace CompanyManageSystem.Model{    [Table("Company")]    public class Company    {        public Guid ID { get; set; }        public String CName { get; set; }        public bool IsEnabled { get; set; }    }}

      (5)在App.config添加資料庫的代碼

<?xml version="1.0" encoding="utf-8"?><configuration>  <connectionStrings>    <add name="PSContext" connectionString="data source=X450V-PC;initial catalog=date;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />  </connectionStrings></configuration>

      (6)添加表單Frm_ShowInfo.cs    (注意：FiledName裡面的名字要和資料庫的列名相同，(Name)裡面的名字盡量不取Name)

添加控制項：

 

namespace CompanyManageSystem{    public partial class Frm_ShowInfo : Form    {        PSContext _db = new PSContext();        public Frm_ShowInfo()        {            InitializeComponent();        }        private void Frm_ShowInfo_Load(object sender, EventArgs e)        {            CompanyGrid.DataSource = _db.Companys.AsNoTracking().ToList();        }    }}

         (7)在Program.cs啟動Frm_ShowInfo.cs視窗

namespace CompanyManageSystem{    static class Program    {        /// <summary>        /// The main entry point for the application.        /// </summary>        [STAThread]        static void Main()        {            Application.EnableVisualStyles();            Application.SetCompatibleTextRenderingDefault(false);            BonusSkins.Register();            SkinManager.EnableFormSkins();            UserLookAndFeel.Default.SetSkinStyle("DevExpress Style");            Application.Run(new Frm_ShowInfo());        }    }}

 

C#------EntityFramework實體載入資料庫