public void ExecutePagingStoredProcedureCount() { DataTable table = null; int errorNumber = 0; string errorDescription = null; Framework.DataServices.PagingDatabase database = new Framework.DataServices.PagingDatabase( CommonDatabase.ConnectionName, CommonDatabase.ConnectionString, CommonDatabase.ProviderName); int total = database.GetCount(StoredProcedureCount, "Users", "Children > 0", 0, 2, false, CommonDatabase.CurrentUser, out errorNumber, out errorDescription); }
public void ExecutePagingStoredProcedureWithDefaultParameters() { DataTable table = null; int errorNumber = 0; string errorDescription = null; Framework.DataServices.PagingDatabase database = new Framework.DataServices.PagingDatabase( CommonDatabase.ConnectionName, CommonDatabase.ConnectionString, CommonDatabase.ProviderName); table = database.GetPage(StoredProcedurePageWithDefaultParameters, "ID, FirstName, BirthDate", "Users", "Children > 0", "FirstName", 0, 2, true, CommonDatabase.CurrentUser, out errorNumber, out errorDescription); }