EF6 SqlServer 简单例子 和 支持的原生sql例子
总体结构如图：
1. 使用NuGet添加EF6
2. 添加实体Model
public class User_Model {
public int ID { get; set; }
public string S_UserID { get; set; }
public int Sex { get; set; }
public string Phone { get; set; }
public int Age { get; set; }
public DateTime? AddDateTime { get; set; }
public DateTime? UpdDateTime { get; set; }
} 3. 创建Map(Model成员约束)
public class User_Map : EntityTypeConfiguration<Model.User_Model> {
public User_Map() {
ToTable("3660_kangwl.Users");//自定义表名
this.HasKey(u => u.ID);//主键
this.Property(u => u.ID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);//自增张字段
this.Property(u => u.AddDateTime).HasColumnName("Add_DateTime").IsRequired();
this.Property(u => u.S_UserID).HasColumnName("S_User_ID");
this.Property(u => u.UpdDateTime).HasColumnName("Update_DateTime").IsOptional();
}
} 4. 创建数据库上下文 Context
public class Smile : DbContext {
public Smile() :base() {
Database.Connection.ConnectionString =
System.Configuration.ConfigurationManager.ConnectionStrings["smile"].ConnectionString;
Database.SetInitializer(new NullDatabaseInitializer<Smile>());
}
public DbSet<Model.User_Model> User { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder) {
modelBuilder.Configurations.Add(new User_Map());
base.OnModelCreating(modelBuilder);
}
} 5. 操作代码
class Program
{
private static void Main(string[] args) {
Smile smile = new Smile();
var users = smile.User;
foreach (User_Model user in users) {
Console.WriteLine(user.S_UserID);
}
//由于加了实体与数据库字段映射
//下面的sql查询用了as转换成映射字段，否则取不出来的
//切记，切记
//Add_DateTime（数据库字段），AddDateTime（映射字段）
var rawSqlUsers =
smile.Database.SqlQuery<Model.User_Model>(
"select id,s_user_id as S_UserID,Sex,Phone,Age,Add_DateTime as AddDateTime,update_datetime as UpdDateTime from users");
foreach (User_Model user in rawSqlUsers) {
Console.WriteLine(user.ID);
}
//command指令如下
//参数id=@p0
int ret = smile.Database.ExecuteSqlCommand("update users set age=-1 where id=@p0", 2);
Console.WriteLine(ret > 0);
//两个参数
int ret1 = smile.Database.ExecuteSqlCommand("update users set age=-1 where id=@p0 and s_user_id=@p1", 12,"kangwl");
Console.WriteLine(ret > 0);
var auser =
smile.Database.SqlQuery<Model.User_Model>(
"select id,s_user_id as S_UserID,Sex,Phone,Age,Add_DateTime as AddDateTime,update_datetime as UpdDateTime from users where id=@p0",
12);
Console.WriteLine(auser.First().Age);
Console.Read();
}
} 6. show 一下配置文件
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<connectionStrings>
<add name="smile" connectionString="server=smile.xxx.xxx;database=3660_smile;uid=3660_kangwl;pwd=xxxxx;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="v11.0" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
</providers>
</entityFramework>
</configuration>
