EF查询返回DataTable

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

using (SchoolContext dbCOntext = new SchoolContext())             {                 string str = "select * from student";                 System.Data.Common.DbCommand cmd = dbCOntext.Database.Connection.CreateCommand();                 cmd.CommandText = str;                 cmd.CommandType = CommandType.Text;                 //转成sqlcommand正常查询语句。                 MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter();                 da.SelectCommand = cmd as MySql.Data.MySqlClient.MySqlCommand;                 DataTable dt = new DataTable();                 da.Fill(dt);                   //List<Student> lst = (from d in dbCOntext.Students where d.StudentName == "New Student" select d).ToList();                 //List<Student> lst1 = (from d in dbCOntext.Students select d).ToList();             }

根据上文EF动态新建数据库/表

常用EF指令

1.Add-Migration 添加一个新的迁移（名词）,string是迁移的名称
2.remove-Migration 删除上一次的迁移
3.Update-Database 更新最近一次的迁移到数据库（有时候可能与原来的数据库产生冲突，所以可能并不能迁移到数据库）
4.Update-Database -Migration 0 表示清空数据库，回到空数据库状态
5.Script-Migration 查看迁移脚本

6 Enable-Migrations  申请开始迁移