个人建购物网站 备案,平面设计软件ps,网站排名推广自己怎么做,站酷网站源码前面有说明使用EF动态新建数据库与表#xff0c;数据库使用的是SQL SERVER2008的#xff0c;在使用MYSQL的时候还是有所不同 一、添加 EntityFramework.dll #xff0c;System.Data.Entity.dll #xff0c;MySql.Data, MySql.Data.Entity.EF6 注意#xff1a;Entity Frame…前面有说明使用EF动态新建数据库与表数据库使用的是SQL SERVER2008的在使用MYSQL的时候还是有所不同 一、添加 EntityFramework.dll System.Data.Entity.dll MySql.Data, MySql.Data.Entity.EF6 注意Entity Framework5.0.0(好像最新的6.X是不支持mysql的) 二、添加dll文件可以使用“管理NuGet程序包”或者“Nuget程序包管理控制台”添加 与 控制台平台添加 以下为控制台平台安装dll语句 EntityFramework.dll Install-Package EntityFramework -Version 5.0.0 MySql.Data Install-Package MySql.Data -Version 6.9.12 MySql.Data.EntityInstall-Package MySql.Data.Entity -Version 6.9.12 三、在app.config文件中添加connectionStrings 源文件 ?xml version1.0 encodingutf-8?
configurationconfigSectionssection nameentityFramework typeSystem.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version6.0.0.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 requirePermissionfalse /!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID237468 --/configSectionsentityFrameworkdefaultConnectionFactory typeSystem.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework /providersprovider invariantNameSystem.Data.SqlClient typeSystem.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer /provider invariantNameMySql.Data.MySqlClient typeMySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version6.9.12.0, Cultureneutral, PublicKeyTokenc5687fc88969c44d/provider/providers/entityFrameworksystem.dataDbProviderFactoriesremove invariantMySql.Data.MySqlClient /add nameMySQL Data Provider invariantMySql.Data.MySqlClient description.Net Framework Data Provider for MySQL typeMySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version6.9.12.0, Cultureneutral, PublicKeyTokenc5687fc88969c44d //DbProviderFactories/system.dataconnectionStrings!--add nameconncodefirst connectionStringserver127.0.0.1;port3306;uidroot;pwdrepower;databasecode providerNameMySql.Data.MySqlClient/--add nameconncodefirst connectionStringserver127.0.0.1;user idroot;passwordrepower;databasecode providerNameMySql.Data.MySqlClient //connectionStrings
/configuration四、添加类 [Table(Student)]public class Student{public Student(){}[Key]public int StudentID { get; set; }public string StudentName { get; set; }public DateTime AddTime { get; set; }}[Table(Standard)]public class Standard{public Standard(){}public int StandardId { get; set; }public string StandardName { get; set; }public DateTime AddTime { get; set; }}添加SchoolContext 继承DbContext [DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]public class SchoolContext : DbContext{public SchoolContext(): base(nameconncodefirst){}static SchoolContext(){DbConfiguration.SetConfiguration(new MySql.Data.Entity.MySqlEFConfiguration());}public DbSetStudent Students { get; set; }public DbSetStandard Standards { get; set; }//protected override void OnModelCreating(DbModelBuilder modelBuilder)//{// base.OnModelCreating(modelBuilder);//}}最后调用 SchoolContext dbCOntext new SchoolContext();//dbCOntext.Database.bool flag dbCOntext.Database.CreateIfNotExists();Student stud new Student() { StudentName New Student, AddTime DateTime.Now };dbCOntext.Students.Add(stud);dbCOntext.SaveChanges();结果 转载于:https://www.cnblogs.com/wangyonglai/p/10308198.html
