public void TestInsertWithStaticTypeObject() { var user = new User { Name = "Steve", Age = 50 }; _db.Users.Insert(user); GeneratedSqlIs("insert into [dbo].[Users] ([Name],[Password],[Age]) values (@p0,@p1,@p2)"); Parameter(0).Is("Steve"); Parameter(1).Is(DBNull.Value); Parameter(2).Is(50); }
public void TestUpdateByWithStaticObject() { var mockDatabase = new MockDatabase(); dynamic database = CreateDatabase(mockDatabase); var user = new User { Id = 1, Name = "Steve", Age = 50 }; database.foo.Users.UpdateById(user); Assert.AreEqual("update [foo].[Users] set [Name] = @p1, [Password] = @p2, [Age] = @p3 where [foo].[Users].[Id] = @p4".ToLowerInvariant(), mockDatabase.Sql.ToLowerInvariant()); Assert.AreEqual("Steve", mockDatabase.Parameters[0]); Assert.AreEqual(DBNull.Value, mockDatabase.Parameters[1]); Assert.AreEqual(50, mockDatabase.Parameters[2]); Assert.AreEqual(1, mockDatabase.Parameters[3]); }
public void TestUpdateWithStaticObjectWithShoutyCase() { var user = new User { Id = 1, Name = "Steve", Age = 50 }; _db.UserTable.Update(user); GeneratedSqlIs( "update [dbo].[USER_TABLE] set [NAME] = @p1, [PASSWORD] = @p2, [AGE] = @p3 where [dbo].[USER_TABLE].[ID] = @p4"); Parameter(0).Is("Steve"); Parameter(1).IsDBNull(); Parameter(2).Is(50); Parameter(3).Is(1); }
public void TestUpdateByWithStaticObject() { var user = new User { Id = 1, Name = "Steve", Age = 50 }; _db.Users.UpdateById(user); GeneratedSqlIs( "update [dbo].[Users] set [Name] = @p1, [Password] = @p2, [Age] = @p3 where [dbo].[Users].[Id] = @p4"); Parameter(0).Is("Steve"); Parameter(1).IsDBNull(); Parameter(2).Is(50); Parameter(3).Is(1); }
public void TestUpdateWithStaticObjectsAndOriginalObject() { var newUser = new User { Id = 1, Name = "Steve-o", Age = 50 }; var originalUser = new User { Id = 1, Name = "Steve", Age = 50 }; _db.Users.Update(new[] {newUser}, new[] {originalUser}); GeneratedSqlIs("update [dbo].[Users] set [Name] = @p1 where ([dbo].[Users].[Id] = @p2 and [dbo].[Users].[Name] = @p3)"); Parameter(0).Is("Steve-o"); Parameter(1).Is(1); Parameter(2).Is("Steve"); }
public void TestUpdateByWithStaticObject() { var mockDatabase = new MockDatabase(); dynamic database = CreateDatabase(mockDatabase); var user = new User { Id = 1, Name = "Steve", Age = 50 }; using (var transaction = database.BeginTransaction()) { transaction.Users.UpdateById(user); transaction.Commit(); } Assert.AreEqual("update [dbo].[Users] set [Name] = @p1, [Password] = @p2, [Age] = @p3 where [dbo].[Users].[Id] = @p4".ToLowerInvariant(), mockDatabase.Sql.ToLowerInvariant()); Assert.AreEqual("Steve", mockDatabase.Parameters[0]); Assert.AreEqual(DBNull.Value, mockDatabase.Parameters[1]); Assert.AreEqual(50, mockDatabase.Parameters[2]); Assert.AreEqual(1, mockDatabase.Parameters[3]); Assert.IsTrue(MockDbTransaction.CommitCalled); }
public void TestInsertWithStaticTypeObject() { var mockDatabase = new MockDatabase(); dynamic database = CreateDatabase(mockDatabase); var user = new User { Name = "Steve", Age = 50 }; database.Users.Insert(user); Assert.AreEqual("insert into [dbo].[Users] ([Name],[Password],[Age]) values (@p0,@p1,@p2)".ToLowerInvariant(), mockDatabase.Sql.ToLowerInvariant()); Assert.AreEqual("Steve", mockDatabase.Parameters[0]); Assert.AreEqual(null, mockDatabase.Parameters[1]); Assert.AreEqual(50, mockDatabase.Parameters[2]); }
public void TestUpdateWithStaticObject() { var mockDatabase = new MockDatabase(); dynamic database = CreateDatabase(mockDatabase); var user = new User { Id = 1, Name = "Steve", Age = 50 }; database.Users.Update(user); Assert.AreEqual("update [dbo].[Users] set [Name] = @p1, [Age] = @p2 where [dbo].[Users].[Id] = @p3".ToLowerInvariant(), mockDatabase.Sql.ToLowerInvariant()); Assert.AreEqual("Steve", mockDatabase.Parameters[0]); Assert.AreEqual(50, mockDatabase.Parameters[1]); Assert.AreEqual(1, mockDatabase.Parameters[2]); }
public void TestUpdateWithStaticObjectAndOriginalObject() { var newUser = new User { Id = 1, Name = "Steve", Age = 50 }; var originalUser = new User() {Id = 2, Name = "Steve", Age = 50}; _db.Users.Update(newUser, originalUser); GeneratedSqlIs( "update [dbo].[Users] set [Id] = @p1 where [dbo].[Users].[Id] = @p2"); Parameter(0).Is(1); Parameter(1).Is(2); }