public void UdateEntityTest()
{
using (var data = new SqlDataAccess(STR_ConnectionString))
{
int id = (int) data.ExecuteScalar("select TOP 1 id from customers order by entered");
Console.WriteLine(id);
Customer customer = new Customer()
{
Id = id,
FirstName = "Updated Entry " + DateTime.UtcNow,
Entered = DateTime.UtcNow,
Updated = DateTime.UtcNow
};
// insert into customers and skip Id,Order properties and return id
object newId = data.UpdateEntity(customer, "Customers", "Id", null, "Id,Orders");
Assert.IsNotNull(newId, data.ErrorMessage);
Console.WriteLine(newId);
}
}
public void UpdateEntityOleDbTest()
{
using (var data = new SqlDataAccess(connString, "System.Data.OleDb")
{
LeftFieldBracket = "",
RightFieldBracket = "",
ParameterPrefix = "?",
UsePositionalParameters = true
})
{
var customer = new
{
Id = "_adasdasd ",
FirstName = "Mike Updated",
LastName = "Smith",
Company = "Smith & Smith",
Entered = DateTime.UtcNow,
};
// insert into customers and skip Id,Order properties and return id
object result= data.UpdateEntity(customer, "Customers", "Id", null, "FirstName,Entered,Address");
Console.WriteLine(data.LastSql);
Assert.IsNotNull(result, data.ErrorMessage);
Console.WriteLine(result);
Console.WriteLine(data.ErrorMessage);
Assert.IsNotNull(result,data.ErrorMessage);
}
}
