本文整理汇总了C#中Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase.CreateSqlStringAccessor方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDatabase.CreateSqlStringAccessor方法的具体用法？C# SqlDatabase.CreateSqlStringAccessor怎么用？C# SqlDatabase.CreateSqlStringAccessor使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase的用法示例。
在下文中一共展示了SqlDatabase.CreateSqlStringAccessor方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DataReadMapping
private static void DataReadMapping(SqlDatabase database, MethodType type)
{
IEnumerable<Employee> employeeData;
switch (type)
{
case MethodType.One:
{
// Create an output row mapper that maps all properties based on the column names
IRowMapper<Employee> mapper = MapBuilder<Employee>.BuildAllProperties();
// Create a stored procedure accessor that uses this output mapper
var accessor = database.CreateSqlStringAccessor("SELECT * FROM Employees", mapper);
// Execute the accessor to obtain the results
employeeData = accessor.Execute();
break;
}
case MethodType.Two:
{
employeeData = database.ExecuteSqlStringAccessor<Employee>("SELECT * FROM Employees");
break;
}
case MethodType.Three:
{
IRowMapper<Employee> mapper = MapBuilder<Employee>.MapAllProperties()
.MapByName(x => x.LastName)
.DoNotMap(x => x.TitleOfCourtesy)
.Map(x => x.City).ToColumn("City")
.Map(x => x.HireDate).WithFunc(x => x.GetDateTime(x.GetOrdinal("HireDate")))
.Build();
var accessor = database.CreateSqlStringAccessor("SELECT * FROM Employees", mapper);
employeeData = accessor.Execute();
break;
}
default:
throw new NotSupportedException();
}
// Perform a client-side query on the returned data
var results = from employee in employeeData
where employee.Country == "USA"
orderby employee.EmployeeID
select new { Name = employee.FirstName };
results.ToList().ForEach(obj => Console.WriteLine(obj.Name));
var products = database.ExecuteSprocAccessor<Product>("Ten Most Expensive Products");
products.ToList().ForEach(product => Console.WriteLine(product.TenMostExpensiveProducts, product.UnitPrice));
var sales = database.ExecuteSprocAccessor<Sale>("SalesByCategory", "Beverages", "1998");
sales.ToList().ForEach(sale => Console.WriteLine(sale.ProductName, sale.TotalPurchase));
}