本文整理汇总了C#中BusinessObjects.MapToParams方法的典型用法代码示例。如果您正苦于以下问题：C# BusinessObjects.MapToParams方法的具体用法？C# BusinessObjects.MapToParams怎么用？C# BusinessObjects.MapToParams使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类BusinessObjects的用法示例。
在下文中一共展示了BusinessObjects.MapToParams方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DeletePhoneNumber
public void DeletePhoneNumber(BusinessObjects.PersonPhone phoneNumber)
{
// SQL query deleting row from Person.PersonPhone
string query = "DELETE FROM Person.PersonPhone "
+ "WHERE BusinessEntityID = @BusinessEntityID AND PhoneNumber = @PhoneNumber AND PhoneNumberTypeID = @PhoneNumberTypeID";
// Execute query
cnn.Execute(query, phoneNumber.MapToParams());
}示例2: UpdateEmployee
public void UpdateEmployee(BusinessObjects.Employee employee)
{
// Paramaterised SQL query, update both tables
string query = "UPDATE HumanResources.Employee SET JobTitle = @JobTitle WHERE BusinessEntityID = @BusinessEntityID; "
+ "UPDATE Person.Person SET FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName WHERE BusinessEntityID = @BusinessEntityID";
// Send SQL to DB
int rowsAffected = cnn.Execute(query, employee.MapToParams());
}示例3: AddPhoneNumber
public void AddPhoneNumber(BusinessObjects.PersonPhone phoneNumber)
{
// SQL query adding new row to Person.PersonPhone
string query = "INSERT INTO Person.PersonPhone (BusinessEntityID, PhoneNumber, PhoneNumberTypeID) "
+ "VALUES (@BusinessEntityID, @PhoneNumber, @PhoneNumberTypeID)";
// Execute query
cnn.Execute(query, phoneNumber.MapToParams());
}