本文整理汇总了C#中Westwind.Utilities.Data.SqlDataAccess.UpdateEntity方法的典型用法代码示例。如果您正苦于以下问题:C# SqlDataAccess.UpdateEntity方法的具体用法?C# SqlDataAccess.UpdateEntity怎么用?C# SqlDataAccess.UpdateEntity使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Westwind.Utilities.Data.SqlDataAccess
的用法示例。
在下文中一共展示了SqlDataAccess.UpdateEntity方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UdateEntityTest
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);
}
}
示例2: UpdateEntityOleDbTest
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);
}
}