public void Update_Should_Set_DBType_For_Settings() { var provider = ProviderFactory.GetProvider("Northwind"); var qry = new Update<SouthWind.Order>(provider) .Set("RequiredDate").EqualTo(DateTime.Parse("1/12/2001")); var cmd = qry.GetCommand(); Assert.Equal(cmd.Parameters[0].DataType, DbType.DateTime); }
public void Github_Issue210_Update_Should_Support_Boolean_And_Constraints() { var provider = ProviderFactory.GetProvider("Northwind"); var qry = new Update<SouthWind.Order>(provider) .Where(x=> x.EmployeeID < 100 && x.OrderID > 100) .Set("RequiredDate").EqualTo(new DateTime(2001, 12, 1)); Assert.Contains("WHERE [Orders].[EmployeeID] < @0 AND [Orders].[OrderID] > @1", qry.GetCommand().CommandSql); }
public void Github_Issue210_Update_Should_Support_GreaterThan_Comparison_Constraints() { var provider = ProviderFactory.GetProvider("Northwind"); var qry = new Update<SouthWind.Order>(provider) .Where(x => x.EmployeeID > 100) .Set("RequiredDate").EqualTo(new DateTime(2001, 12, 1)); Assert.Contains("[Orders].[EmployeeID] > @0", qry.GetCommand().CommandSql); }
public void Github_Issue211_Update_Should_Support_IsNotNull_Constraint() { var provider = ProviderFactory.GetProvider("Northwind"); var qry = new Update<SouthWind.Order>(provider) .Where(o => o.EmployeeID != null) .Set("RequiredDate").EqualTo(new DateTime(2001, 12, 1)); Assert.Contains("IS NOT NULL", qry.GetCommand().CommandSql); }
public void Github_Issue246_Update_Should_Support_Set_To_Null() { var provider = ProviderFactory.GetProvider("Northwind"); var qry = new Update<SouthWind.Category>(provider) .Where(x => x.Picture == null) .Set(x => x.Description == null); Assert.Contains("SET [Categories].[Description]=@up_Description", qry.GetCommand().CommandSql); Assert.Contains("WHERE [Categories].[Picture] IS NULL", qry.GetCommand().CommandSql); }