本文整理汇总了C#中SqlExecutor.ExecuteScript方法的典型用法代码示例。如果您正苦于以下问题：C# SqlExecutor.ExecuteScript方法的具体用法？C# SqlExecutor.ExecuteScript怎么用？C# SqlExecutor.ExecuteScript使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlExecutor的用法示例。
在下文中一共展示了SqlExecutor.ExecuteScript方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetPaginated_Customer_Succeed
public void GetPaginated_Customer_Succeed(PaginatedData paginatedData)
{
//Arrange
using (var context = new ManagementContext())
{
var executor = new SqlExecutor(context.Database.Connection.ConnectionString);
executor.ExecuteScript(Path.Combine(Environment.CurrentDirectory, "Scripts", "2 - Customers.sql"));
var unitOfWork = new DatabaseUnitOfWork(context);
var customerRepository = new CustomerRepository(unitOfWork);
//Act
PaginatedResult<Customer> result = customerRepository.GetPaginated(null, null, p => p.Id, paginatedData.PageIndex, paginatedData.PageSize);
//Assert
Assert.AreEqual(paginatedData.ResultCount, result.Result.Count());
Assert.AreEqual(paginatedData.PageIndex, result.PageIndex);
Assert.AreEqual(paginatedData.PageSize, result.PageSize);
Assert.AreEqual(paginatedData.TotalCount, result.TotalCount);
Assert.AreEqual(paginatedData.TotalPageCount, result.TotalPageCount);
Assert.AreEqual(paginatedData.HasPreviousPage, result.HasPreviousPage);
Assert.AreEqual(paginatedData.HasNextPage, result.HasNextPage);
}
}示例2: GetAllWithPredicates_Customer_Succeed
public void GetAllWithPredicates_Customer_Succeed()
{
//Arrange
using (var context = new ManagementContext())
{
var executor = new SqlExecutor(context.Database.Connection.ConnectionString);
executor.ExecuteScript(Path.Combine(Environment.CurrentDirectory, "Scripts", "2 - Customers.sql"));
var unitOfWork = new DatabaseUnitOfWork(context);
var customerRepository = new CustomerRepository(unitOfWork);
//Act
var predicates = CustomerRepository.Predicates(p => p.Id > 2, p => p.Code.StartsWith("A"));
var total = customerRepository.GetAll<Customer>(predicates, null, null).Count();
//Assert
Assert.AreEqual(3, total);
}
}