public void SqlQueryEntitiesTest() { using (var context = new FakeEcDbContext()) { var users = context.Set <FakeUser>().SqlQuery("SELECT * TOP 10 FROM [FakeUser]").ToList(); var users2 = context.Set <FakeUser>().SqlQuery("SELECT * TOP 10 FROM [FakeUser] WHERE [Username] = @username", new SqlParameter("@username", "zhangsan")).ToList(); } }
public void SqlQueriesForNoEntityTypeTest() { using (var context = new FakeEcDbContext()) { //var users = context.Database.FromSql<string>("SELECT [Name] FROM [FakeUser] WHERE [Id] = @id",new SqlParameter("@id", 1)).FirstOrDefault(); throw new NotImplementedException(); } }
public void SqlQueriesForNoEntityTypeTest() { using (var context = new FakeEcDbContext()) { var users = context.Database.SqlQuery <string>("SELECT [Name] FROM [FakeUser] WHERE [Id] = @id", new SqlParameter("@id", 1)).FirstOrDefault(); } }
public void StoredProceduleTest() { using (var context = new FakeEcDbContext()) { var users = context.Set <FakeUser>().SqlQuery("dbo.GetUsers").ToList(); var userId = 1; //带参数的存储过程 var users2 = context.Set <FakeUser>().SqlQuery("dbo.GetUsers @p0", userId).ToList(); } }
public void SqlCommandQueryTest() { using (var context = new FakeEcDbContext()) { var num = context.Database.ExecuteSqlCommand("INSERT INTO [FakeUser]([Id], [Username], [Password], [Address], [Mobile], [Email], [Points], [MarkDelete], [CreateDate]) VALUES(@username, @password, @address, @mobile, @email, @points, @markDelete, @createDate)", new SqlParameter("@Id", Guid.NewGuid()), new SqlParameter("@username", "李四"), new SqlParameter("@password", "123456"), new SqlParameter("@address", "XXXX路ZZ号"), new SqlParameter("@mobile", "13911112222"), new SqlParameter("@email", "*****@*****.**"), new SqlParameter("@points", 3), new SqlParameter("@markDelete", false), new SqlParameter("@createDate", DateTime.Now) ); } }