EntityFramework-MySql

通过MySql 来实现EF 功能步骤：

1.建立项目，安装MySql,EntityFramework 相关包

install-package EntityFramework

install-package MySql.Data.Entity

2.建立实体对应的数据库表

引用单元：using System.ComponentModel.DataAnnotations.Schema; //该单元定义了一些属性，用于标注映射关系

[Table("t_person")] //该类映射的数据库中对应的表为 t_person

public class Person{

[Column(id)] //该字段映射表中的字段为id

public int Id{get;set;}

[Column("name")]

public string Name{get;set;}

}

[Table("t_article")]

public class Article{

[Column("id")]

public int Id{get;set;}

[Colunm("person_id")]

public int PersonId{get;set;}

[Column("name")]

public string Name{get;set;}

[Column("description")]

public string Description{get;set;}

}

3.建立表：

mysql -uroot -p

>use test

drop table if exists t_article

create table t_article(id int auto_increment primary key,person_id int not null,name varchar(30),description text)engine=innodb,default charset=utf8;

drop table if exists t_person(int id auto_increment primary key,name varchar(30))engine=innodb,charset=utf8;

4.修改配置文件，增加链接字符串

5.建立实体类

引用单元：using system.data.Entity;

[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))] //这个应该和java 的 Java.Classfor(xxx) 有点类似，指定数据库类型

public class DemoContext:DbContext{

static DemoContext(){

Database.SetInitializer<DemoContext>(null); //实例化是根据指定的数据库类型进行实例化 code-first

}

public DemoContext():base("name=mysqldb"){}

public DbSet<Person> Persons{get;set;}

public DbSet<Article> Articles{get;set;}

}

完整示例：

using System.Data.Entity;

namespace ConsoleMySqlEF.Models
{
[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]
public class DemoContext:DbContext
{
static DemoContext()
{
Database.SetInitializer<DemoContext>(null);
}
public DemoContext() : base("name=mysqldb") { }
public DbSet<Person> Persons { get; set; }
public DbSet<Article> Articles { get; set; }
}
}

调用示例：

using ConsoleMySqlEF.Models;
namespace ConsoleMySqlEF
{
class Program
{
static void Main(string[] args)
{
using (var db = new DemoContext())
{
using (var tran=db.Database.BeginTransaction())
{
try
{
Person person = new Person() { Name = "demo" };
db.Persons.Add(person);
db.SaveChanges();

Article article = new Article()
{
PersonId = person.Id,
Description = "Delphi",
Name = "Test"
};
db.Articles.Add(article);
db.SaveChanges();
tran.Commit();
Console.WriteLine("添加数据成功！");
}
catch(Exception ex) {
tran.Rollback();
throw;
}
}
Console.ReadLine();
}

}
}
}