public void UpdateTest()
{
//Insert first
InsertTest();
using (ShimsContext.Create())
{
//Verify the ExecuteNonQuery will call SqlCommand.ExecuteNonQuery
System.Data.SqlClient.Fakes.ShimSqlCommand.AllInstances.ExecuteNonQuery =
c =>
{
if (!c.CommandText.StartsWithIgnoreCase("UPDATE [dbo].[Categories]"))
{
return(0);
}
if (!c.CommandText.ContainsIgnoreCase("SET [CategoryName] = @CategoryName"))
{
return(0);
}
if (!c.CommandText.ContainsIgnoreCase("WHERE ([CategoryName] LIKE @CategoryName1)"))
{
return(0);
}
if (c.Parameters.Count != 2)
{
return(0);
}
return(1);
};
using (var sql = new SqlQueryBuilderContext(ConnectionName))
{
var update = sql.CreateUpdateQuery();
update.Table("Categories")
.Set("CategoryName").By("Category U")
.Where(c => c.Field("CategoryName").Contains("Category"));
var v = sql.ExecuteNonQuery(update);
Assert.IsTrue(v > 0);
}
}
}
public void InsertTest()
{
using (ShimsContext.Create())
{
//Verify the ExecuteNonQuery will call SqlCommand.ExecuteNonQuery
System.Data.SqlClient.Fakes.ShimSqlCommand.AllInstances.ExecuteNonQuery =
c =>
{
if (!c.CommandText.StartsWithIgnoreCase("INSERT INTO"))
{
return(0);
}
if (!c.CommandText.ContainsIgnoreCase("[dbo].[Categories]([CategoryName])"))
{
return(0);
}
if (!c.CommandText.ContainsIgnoreCase("VALUES (@CategoryName)"))
{
return(0);
}
if (c.Parameters.Count != 1)
{
return(0);
}
return(1);
};
using (var sql = new SqlQueryBuilderContext(ConnectionName))
{
var insert = sql.CreateInsertQuery();
insert.Into("Categories")
.Values("CategoryName").By("Category 1");
var v = sql.ExecuteNonQuery(insert);
Assert.IsTrue(v > 0);
}
}
}
