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);
}
