public void SelectMultipleParam()
{
EntityDataAccess repo = new EntityDataAccess(connectionString);
repo.CommandText = "select * from person where id IN (@ids)";
var list = new List <int>();
list.Add(1);
list.Add(3);
repo.AddParameter("@ids", list);
var value = repo.ExecuteReader <Person>();
Assert.AreEqual(1, value);
}
public async Task ChecProAsync()
{
var repo = new EntityDataAccess(ProconnectionString);
var productsViewParams = new ProductsViewParams();
productsViewParams.CompanyCode = 35;
//productsViewParams.Status = 1;
productsViewParams.Top = 100;
//productsViewParams.KeySearch = "Pixel 2 XL";
repo.CommandText = "dbo.GetProducts";
repo.AddParameter("@CompanyCode", productsViewParams.CompanyCode);
repo.AddParameter("@BranchCode", productsViewParams.BranchCode);
repo.AddParameter("@Top", productsViewParams.Top);
repo.AddParameter("@KeySearch", productsViewParams.KeySearch);
repo.AddParameter("@CategoryID", productsViewParams.CategoryID);
repo.AddParameter("@PType", productsViewParams.PType);
repo.AddParameter("@Status", productsViewParams.Status);
repo.CommandType = EntityDataAccess.ICommandType.StorePrecedure;
var ddd = await repo.ExecuteReaderAsync <ProductsListView>();
Assert.AreEqual(1, ddd);
}
