EF根据实体模型创建数据库
1.先创建一个类
public class Student
{
[Key]
public int Id { get; set; }
[Required]
[StringLength(50)]
public string Name { get; set; }
}
2.创建上下文
public class Models: DbContext
{
public Models()
: base("StudentContext")//指定连接字符串
{ }
public DbSet<Student> Students { get; set; }
}
3.创建触发条件
static void Main(string[] args)
{
try
{
var StudentModel = new Student
{
Name = "王富贵",
};
using (var context = new Models())
{
context.Students.Add(StudentModel);
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine($"数据库创建失败:{ex.Message}");
}
Console.WriteLine("数据库创建成功");
}
4,配置文件
<?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="StudentContext" connectionString="server=.; database=MySql;uid=sa;pwd=123456" providerName="System.Data.SqlClient" />
</connectionStrings>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
</startup>
<entityFramework>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
</providers>
</entityFramework>
</configuration>
5.直接运行
6.看结果