一、单表操作
1. 建表
CREATE TABLE [Chapter1].[Customer] ( [CustomerId] [int] NOT NULL IDENTITY(1, 1), [Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Email] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL, [Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO ALTER TABLE [Chapter1].[Customer] ADD CONSTRAINT [PK_Customer_10] PRIMARY KEY CLUSTERED ([CustomerId]) ON [PRIMARY] GO
2. 创建控制台应用程序 Ex01 ,解决方案名称 EF6xDemo
3. 建立模型
namespace Ex01 { using System; using System.Collections.Generic; public partial class Customer { public int CustomerId { get; set; } public string Name { get; set; } public string Email { get; set; } public string Phone { get; set; } } }
namespace Ex01 { using System; using System.Data.Entity; using System.Data.Entity.Infrastructure; public partial class EFRecipesEntities : DbContext { public EFRecipesEntities() : base("name=EFRecipesEntities") { } protected override void OnModelCreating(DbModelBuilder modelBuilder) { throw new UnintentionalCodeFirstException(); } public virtual DbSet<Customer> Customers { get; set; } } }
二、主从表操作,and 在数据库里没有建立关系的主从表又该怎么操作?
Entity Framework 6.x 学习之Database First
原文:http://www.cnblogs.com/wanghaibin/p/3914683.html