public void Update_WithIdentity_Test()
{
var compiler = new SqlServerCompiler();
var builder = new QueryBuilder <EmployeeWithAttributes>(compiler);
var employeeToUpdate = new EmployeeWithAttributes()
{
Id = 1, Name = "test"
};
var result = builder.Update(employeeToUpdate) as DbCompileResult;
Assert.NotNull(result);
Assert.Equal(2, result.QueryParameters.Count);
Assert.Equal("test", result.QueryParameters["@P0"]);
Assert.Equal(1, result.QueryParameters["@P1"]);
Assert.Equal("UPDATE dbo.employee SET [name] = @P0 WHERE [Id] = @P1", result.SqlQuery);
}
public void Delete_WithWhereExpression_Test()
{
var compiler = new SqlServerCompiler();
var builder = new QueryBuilder <EmployeeWithAttributes>(compiler);
var employeeToUpdate = new EmployeeWithAttributes()
{
Name = "test"
};
var result = builder.Update(employeeToUpdate, e => e.Id == 1) as DbCompileResult;
Assert.NotNull(result);
Assert.Equal(2, result.QueryParameters.Count);
Assert.Equal("test", result.QueryParameters["@P0"]);
Assert.Equal(1, result.QueryParameters["@P1"]);
Assert.Equal("UPDATE dbo.employee SET [name] = @P0 WHERE ([Id] = @P1)", result.SqlQuery);
}
public void Insert_WithColumOrAttribute_Test()
{
var compiler = new MySqlCompiler();
var builder = new QueryBuilder <EmployeeWithAttributes>(compiler);
var employee = new EmployeeWithAttributes()
{
Id = 1,
Name = "Employee Name"
};
var result = builder.Insert(employee) as DbCompileResult;
Assert.NotNull(result.QueryParameters);
Assert.Equal(1, result.QueryParameters.Count);
Assert.Equal(result.QueryParameters["@P0"], employee.Name);
Assert.Equal("INSERT INTO dbo.employee (`name`) VALUES (@P0)", result.SqlQuery);
}