void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
sqlite_sequences = new Query <sqlite_sequence>(provider);
Sales = new Query <Sale>(provider);
Orders = new Query <Order>(provider);
Sellers = new Query <Seller>(provider);
StartCashes = new Query <StartCash>(provider);
OrderItems = new Query <OrderItem>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new sqlite_sequenceTable(DataProvider));
DataProvider.Schema.Tables.Add(new SaleTable(DataProvider));
DataProvider.Schema.Tables.Add(new OrderTable(DataProvider));
DataProvider.Schema.Tables.Add(new SellersTable(DataProvider));
DataProvider.Schema.Tables.Add(new StartCashTable(DataProvider));
DataProvider.Schema.Tables.Add(new OrderItemTable(DataProvider));
}
#endregion
}
private void CreateEmptyQuery(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var bobas = new UltimateQueryable <Boba>(provider);
Assert.AreEqual(bobas.ToString(), "select * from Boba");
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
UserAuthenticationProfiles = new Query <UserAuthenticationProfile>(provider);
UserInRoles = new Query <UserInRole>(provider);
Roles = new Query <Role>(provider);
Users = new Query <User>(provider);
ProgramEvaluatorStage1s = new Query <ProgramEvaluatorStage1>(provider);
PatientAssessments = new Query <PatientAssessment>(provider);
PreAssessments = new Query <PreAssessment>(provider);
ProgramEvaluatorStage2s = new Query <ProgramEvaluatorStage2>(provider);
ProgramEvaluatorStage3s = new Query <ProgramEvaluatorStage3>(provider);
UserRoles = new Query <UserRole>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new UserAuthenticationProfileTable(DataProvider));
DataProvider.Schema.Tables.Add(new UserInRolesTable(DataProvider));
DataProvider.Schema.Tables.Add(new RolesTable(DataProvider));
DataProvider.Schema.Tables.Add(new UserTable(DataProvider));
DataProvider.Schema.Tables.Add(new ProgramEvaluatorStage1Table(DataProvider));
DataProvider.Schema.Tables.Add(new PatientAssessmentTable(DataProvider));
DataProvider.Schema.Tables.Add(new PreAssessmentTable(DataProvider));
DataProvider.Schema.Tables.Add(new ProgramEvaluatorStage2Table(DataProvider));
DataProvider.Schema.Tables.Add(new ProgramEvaluatorStage3Table(DataProvider));
DataProvider.Schema.Tables.Add(new UserRoleTable(DataProvider));
}
#endregion
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
Categories = new Query <Category>(provider);
Customers = new Query <Customer>(provider);
Shippers = new Query <Shipper>(provider);
Suppliers = new Query <Supplier>(provider);
Orders = new Query <Order>(provider);
Products = new Query <Product>(provider);
OrderDetails = new Query <OrderDetail>(provider);
Regions = new Query <Region>(provider);
Employees = new Query <Employee>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new CategoriesTable(DataProvider));
DataProvider.Schema.Tables.Add(new CustomersTable(DataProvider));
DataProvider.Schema.Tables.Add(new ShippersTable(DataProvider));
DataProvider.Schema.Tables.Add(new SuppliersTable(DataProvider));
DataProvider.Schema.Tables.Add(new OrdersTable(DataProvider));
DataProvider.Schema.Tables.Add(new ProductsTable(DataProvider));
DataProvider.Schema.Tables.Add(new OrderDetailsTable(DataProvider));
DataProvider.Schema.Tables.Add(new RegionTable(DataProvider));
DataProvider.Schema.Tables.Add(new EmployeesTable(DataProvider));
}
#endregion
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
TextLogs = new Query <TextLog>(provider);
PushLogs = new Query <PushLog>(provider);
EmailBodies = new Query <EmailBody>(provider);
TextBodies = new Query <TextBody>(provider);
PushBodies = new Query <PushBody>(provider);
MethodLogs = new Query <MethodLog>(provider);
MethodLogExceptions = new Query <MethodLogException>(provider);
MethodLogErrors = new Query <MethodLogError>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new TextLogTable(DataProvider));
DataProvider.Schema.Tables.Add(new PushLogTable(DataProvider));
DataProvider.Schema.Tables.Add(new EmailBodyTable(DataProvider));
DataProvider.Schema.Tables.Add(new TextBodyTable(DataProvider));
DataProvider.Schema.Tables.Add(new PushBodyTable(DataProvider));
DataProvider.Schema.Tables.Add(new MethodLogTable(DataProvider));
DataProvider.Schema.Tables.Add(new MethodLogExceptionTable(DataProvider));
DataProvider.Schema.Tables.Add(new MethodLogErrorTable(DataProvider));
}
#endregion
}
public Northwind(DbConnection connection)
{
QueryProvider provider = new DbQueryProvider(connection);
Customers = new Query <Customers>(provider);
Orders = new Query <Orders>(provider);
}
public static Expression IsAllowedExpression(Expression entity, TypeAllowedBasic requested, bool inUserInterface)
{
Type type = entity.Type;
TypeAllowedAndConditions tac = GetAllowed(type);
Expression baseValue = Expression.Constant(tac.FallbackOrNone.Get(inUserInterface) >= requested);
var expression = tac.Conditions.Aggregate(baseValue, (acum, tacRule) =>
{
var lambda = TypeConditionLogic.GetCondition(type, tacRule.TypeCondition);
var exp = (Expression)Expression.Invoke(lambda, entity);
if (tacRule.Allowed.Get(inUserInterface) >= requested)
{
return(Expression.Or(exp, acum));
}
else
{
return(Expression.And(Expression.Not(exp), acum));
}
});
var cleaned = DbQueryProvider.Clean(expression, false, null) !;
var orsSimplified = AndOrSimplifierVisitor.SimplifyOrs(cleaned);
return(orsSimplified);
}
public TestDb(IDataProvider provider)
{
_provider = provider;
_queryProvider = new DbQueryProvider(provider);
Orders = new Query <Order>(provider);
}
public BatchQuery(IDataProvider dbProvider, DbQueryProvider queryProvider)
{
_queries = new List <ISqlQuery>();
_linqProvider = queryProvider;
_provider = dbProvider;
_fixedCommands = new List <QueryCommand>();
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
players = new Query <player>(provider);
characters = new Query <character>(provider);
feats = new Query <feat>(provider);
playercharacters = new Query <playercharacter>(provider);
characterfeats = new Query <characterfeat>(provider);
lammies = new Query <lammy>(provider);
characterlammies = new Query <characterlammy>(provider);
logfiles = new Query <logfile>(provider);
forgotpasswords = new Query <forgotpassword>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new playersTable(DataProvider));
DataProvider.Schema.Tables.Add(new charactersTable(DataProvider));
DataProvider.Schema.Tables.Add(new featsTable(DataProvider));
DataProvider.Schema.Tables.Add(new playercharactersTable(DataProvider));
DataProvider.Schema.Tables.Add(new characterfeatsTable(DataProvider));
DataProvider.Schema.Tables.Add(new lammiesTable(DataProvider));
DataProvider.Schema.Tables.Add(new characterlammiesTable(DataProvider));
DataProvider.Schema.Tables.Add(new logfileTable(DataProvider));
DataProvider.Schema.Tables.Add(new forgotpasswordsTable(DataProvider));
}
#endregion
}
private void CreateGetAllTable(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.AsEnumerable();
Assert.AreEqual(paynes.Count(), 4);
}
private void CreateSimpleSelect(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable<MajorPayne>(provider)
.Select(payne => payne.Height)
.AsEnumerable();
Assert.AreEqual(paynes.Count(), 4);
}
public BatchQuery(IDataProvider provider)
{
_queries = new List <ISqlQuery>();
_linqProvider = new DbQueryProvider(provider);
sb = new StringBuilder();
_provider = provider;
_fixedCommands = new List <QueryCommand>();
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
Users = new Query <User>(provider);
Stores = new Query <Store>(provider);
Images = new Query <Image>(provider);
Facebooks = new Query <Facebook>(provider);
UserBatchAssigneds = new Query <UserBatchAssigned>(provider);
CategoryImagesMappings = new Query <CategoryImagesMapping>(provider);
AppUsers = new Query <AppUser>(provider);
Reviews = new Query <Review>(provider);
BoardContributors = new Query <BoardContributor>(provider);
BoardsImagesMappings = new Query <BoardsImagesMapping>(provider);
Likes = new Query <Like>(provider);
Prizes = new Query <Prize>(provider);
Roulettes = new Query <Roulette>(provider);
PrizeHistories = new Query <PrizeHistory>(provider);
FollowingUsers = new Query <FollowingUser>(provider);
Comments = new Query <Comment>(provider);
Ratings = new Query <Rating>(provider);
Boards = new Query <Board>(provider);
Points = new Query <Point>(provider);
PointsHistories = new Query <PointsHistory>(provider);
Articles = new Query <Article>(provider);
Categories = new Query <Category>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new UserTable(DataProvider));
DataProvider.Schema.Tables.Add(new StoresTable(DataProvider));
DataProvider.Schema.Tables.Add(new ImagesTable(DataProvider));
DataProvider.Schema.Tables.Add(new FacebookTable(DataProvider));
DataProvider.Schema.Tables.Add(new UserBatchAssignedTable(DataProvider));
DataProvider.Schema.Tables.Add(new CategoryImagesMappingTable(DataProvider));
DataProvider.Schema.Tables.Add(new AppUsersTable(DataProvider));
DataProvider.Schema.Tables.Add(new ReviewTable(DataProvider));
DataProvider.Schema.Tables.Add(new BoardContributorTable(DataProvider));
DataProvider.Schema.Tables.Add(new BoardsImagesMappingTable(DataProvider));
DataProvider.Schema.Tables.Add(new LikesTable(DataProvider));
DataProvider.Schema.Tables.Add(new PrizeTable(DataProvider));
DataProvider.Schema.Tables.Add(new RouletteTable(DataProvider));
DataProvider.Schema.Tables.Add(new PrizeHistoryTable(DataProvider));
DataProvider.Schema.Tables.Add(new FollowingUserTable(DataProvider));
DataProvider.Schema.Tables.Add(new CommentsTable(DataProvider));
DataProvider.Schema.Tables.Add(new RatingsTable(DataProvider));
DataProvider.Schema.Tables.Add(new BoardsTable(DataProvider));
DataProvider.Schema.Tables.Add(new PointsTable(DataProvider));
DataProvider.Schema.Tables.Add(new PointsHistoryTable(DataProvider));
DataProvider.Schema.Tables.Add(new ArticlesTable(DataProvider));
DataProvider.Schema.Tables.Add(new CategoryTable(DataProvider));
}
#endregion
}
private void CreateWhereWithSimplePredicate(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Where(payne => payne.Height > 170)
.AsEnumerable();
Assert.AreEqual(paynes.Count(), 2);
}
private void CreateDummySelect(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Select(payne => payne);
Assert.AreEqual(
paynes.ToString(),
"select * from (select * from MajorPayne) as T ");
}
private void CreateComplexWhereRequest(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Where(payne => payne.Height >= 170 && payne.Song == "AAAA");
Assert.AreEqual(
paynes.ToString(),
"select * from (select * from MajorPayne) as T where ((Height >= 170) and (Song = 'AAAA'))");
}
private void CreateSimpleWhereEqualsQuery(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var bobas = new UltimateQueryable <Boba>(provider)
.Where(boba => boba.Feet == false);
Assert.AreEqual(
bobas.ToString(),
"select * from (select * from Boba) as T where (Feet = 0)");
}
private void CreateWhereWithCapturedVariable(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var song = "BBBB";
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Where(payne => payne.Song == song);
Assert.AreEqual(
paynes.ToString(),
"select * from (select * from MajorPayne) as T where (Song = 'BBBB')");
}
private void Init()
{
//Users = new DbRepository<BusinessObjects.Users>(base.co)
IQueryProvider provider = new DbQueryProvider(Connection);
Users = new MyQueryable <User>(provider);
Rights = new MyQueryable <Rights>(provider);
UserRights = new MyQueryable <UserRight>(provider);
Groups = new MyQueryable <Groups>(provider);
GroupUsers = new MyQueryable <GroupUser>(provider);
GroupRights = new MyQueryable <GroupRight>(provider);
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
Advertisement = new Query <DataAccess.Model.Advertisement>(provider);
AdvertisingPosition = new Query <DataAccess.Model.AdvertisingPosition>(provider);
Branch = new Query <DataAccess.Model.Branch>(provider);
ErrorLog = new Query <DataAccess.Model.ErrorLog>(provider);
Information = new Query <DataAccess.Model.Information>(provider);
InformationClass = new Query <DataAccess.Model.InformationClass>(provider);
LoginLog = new Query <DataAccess.Model.LoginLog>(provider);
Manager = new Query <DataAccess.Model.Manager>(provider);
MenuInfo = new Query <DataAccess.Model.MenuInfo>(provider);
OnlineUsers = new Query <DataAccess.Model.OnlineUsers>(provider);
PagePowerSign = new Query <DataAccess.Model.PagePowerSign>(provider);
PagePowerSignPublic = new Query <DataAccess.Model.PagePowerSignPublic>(provider);
Position = new Query <DataAccess.Model.Position>(provider);
UploadConfig = new Query <DataAccess.Model.UploadConfig>(provider);
UploadFile = new Query <DataAccess.Model.UploadFile>(provider);
UploadType = new Query <DataAccess.Model.UploadType>(provider);
UseLog = new Query <DataAccess.Model.UseLog>(provider);
V_Position_Branch = new Query <DataAccess.Model.V_Position_Branch>(provider);
WebConfig = new Query <DataAccess.Model.WebConfig>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new AdvertisementStructs(DataProvider));
DataProvider.Schema.Tables.Add(new AdvertisingPositionStructs(DataProvider));
DataProvider.Schema.Tables.Add(new BranchStructs(DataProvider));
DataProvider.Schema.Tables.Add(new ErrorLogStructs(DataProvider));
DataProvider.Schema.Tables.Add(new InformationStructs(DataProvider));
DataProvider.Schema.Tables.Add(new InformationClassStructs(DataProvider));
DataProvider.Schema.Tables.Add(new LoginLogStructs(DataProvider));
DataProvider.Schema.Tables.Add(new ManagerStructs(DataProvider));
DataProvider.Schema.Tables.Add(new MenuInfoStructs(DataProvider));
DataProvider.Schema.Tables.Add(new OnlineUsersStructs(DataProvider));
DataProvider.Schema.Tables.Add(new PagePowerSignStructs(DataProvider));
DataProvider.Schema.Tables.Add(new PagePowerSignPublicStructs(DataProvider));
DataProvider.Schema.Tables.Add(new PositionStructs(DataProvider));
DataProvider.Schema.Tables.Add(new UploadConfigStructs(DataProvider));
DataProvider.Schema.Tables.Add(new UploadFileStructs(DataProvider));
DataProvider.Schema.Tables.Add(new UploadTypeStructs(DataProvider));
DataProvider.Schema.Tables.Add(new UseLogStructs(DataProvider));
DataProvider.Schema.Tables.Add(new V_Position_BranchStructs(DataProvider));
DataProvider.Schema.Tables.Add(new WebConfigStructs(DataProvider));
}
#endregion
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
#endregion
#region ' Schemas '
#endregion
}
public void Part02ConstQueryFormatterTest()
{
using (DbConnection con = CreateSqLiteConnection()) {
var provider = new DbQueryProvider(con)
{
Log = _TestOutWriter
};
var query = new Query <Customers>(provider);
var command = query.ToString();
Assert.StartsWith("SELECT", command);
}
Assert.True(true);
}
private void TestMethod()
{
string connStr = ConfigurationManager.ConnectionStrings["example"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
DbQueryProvider provider = new DbQueryProvider(conn);
DbQuery <Student> student = new DbQuery <Student>(provider);
student.Where(obj => obj.ID > 5).Select(obj => new { StudentID = obj.ID, StudentName = obj.Name })
.OrderBy(obj => obj.StudentID).ToList().ForEach(obj =>
{
Console.WriteLine(" StudentID:{0} \t StudentName:{1} ", obj.StudentID, obj.StudentName);
});
}
public void ExecuteAsync_throws_OperationCanceledException_if_task_is_cancelled()
{
var internalContext = new Mock<InternalContext>().Object;
var queryProvider = new DbQueryProvider(internalContext, new Mock<InternalQuery<object>>(internalContext).Object);
Assert.Throws<OperationCanceledException>(
() => ((IDbAsyncQueryProvider)queryProvider)
.ExecuteAsync(new Mock<Expression>().Object, new CancellationToken(canceled: true))
.GetAwaiter().GetResult());
Assert.Throws<OperationCanceledException>(
() => ((IDbAsyncQueryProvider)queryProvider)
.ExecuteAsync<object>(new Mock<Expression>().Object, new CancellationToken(canceled: true))
.GetAwaiter().GetResult());
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
Simplests = new Query <Simplest>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new SimplestsTable(DataProvider));
}
#endregion
}
public static T GetValue <T>(DbQueryProvider provider, IDataReader reader, int ordinal)
{
if (reader.IsDBNull(ordinal))
{
return(default(T));
}
object value = reader.GetValue(ordinal);
Type ttype = typeof(T);
Type vtype = value.GetType();
if (vtype != ttype)
{
return((T)provider.Convert(value, ttype));
}
return((T)value);
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
Users = new Query <User>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new UserTable(DataProvider));
}
#endregion
}
public TestDB(IDataProvider provider)
{
_provider = provider;
_queryProvider = new DbQueryProvider(_provider);
Products = new Query <Product>(provider);
Customers = new Query <Customer>(provider);
Orders = new Query <Order>(provider);
OrderDetails = new Query <OrderDetail>(provider);
Categories = new Query <Category>(provider);
_provider.Schema.Tables.Add(typeof(Product).ToSchemaTable(_provider));
_provider.Schema.Tables.Add(typeof(Customer).ToSchemaTable(_provider));
_provider.Schema.Tables.Add(typeof(Order).ToSchemaTable(_provider));
_provider.Schema.Tables.Add(typeof(OrderDetail).ToSchemaTable(_provider));
_provider.Schema.Tables.Add(typeof(Category).ToSchemaTable(_provider));
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
Branch = new Query <DataAccess.Model.Branch>(provider);
Position = new Query <DataAccess.Model.Position>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new BranchStructs(DataProvider));
DataProvider.Schema.Tables.Add(new PositionStructs(DataProvider));
}
#endregion
}
void Init()
{
provider = new DbQueryProvider(this.Provider);
#region ' Query Defs '
BillOfLadingRequestedCarTypeAttributes = new Query <BillOfLadingRequestedCarTypeAttribute>(provider);
CarTypes = new Query <CarType>(provider);
Settings = new Query <Setting>(provider);
BillOfLadings = new Query <BillOfLading>(provider);
SwitchListsLayouts = new Query <SwitchListsLayout>(provider);
Waybills = new Query <Waybill>(provider);
rfids = new Query <rfid>(provider);
EmptyCarBills = new Query <EmptyCarBill>(provider);
ARRCodes = new Query <ARRCode>(provider);
CarTypeAttributes = new Query <CarTypeAttribute>(provider);
rollingStockAtrributes = new Query <rollingStockAtrribute>(provider);
Locations = new Query <Location>(provider);
ConsigneeShippers = new Query <ConsigneeShipper>(provider);
BillOfLadingPaths = new Query <BillOfLadingPath>(provider);
RollingStocks = new Query <RollingStock>(provider);
#endregion
#region ' Schemas '
if (DataProvider.Schema.Tables.Count == 0)
{
DataProvider.Schema.Tables.Add(new BillOfLadingRequestedCarTypeAttributeTable(DataProvider));
DataProvider.Schema.Tables.Add(new CarTypeTable(DataProvider));
DataProvider.Schema.Tables.Add(new SettingsTable(DataProvider));
DataProvider.Schema.Tables.Add(new BillOfLadingTable(DataProvider));
DataProvider.Schema.Tables.Add(new SwitchListsLayoutsTable(DataProvider));
DataProvider.Schema.Tables.Add(new WaybillsTable(DataProvider));
DataProvider.Schema.Tables.Add(new rfidTable(DataProvider));
DataProvider.Schema.Tables.Add(new EmptyCarBillTable(DataProvider));
DataProvider.Schema.Tables.Add(new ARRCodesTable(DataProvider));
DataProvider.Schema.Tables.Add(new CarTypeAttributesTable(DataProvider));
DataProvider.Schema.Tables.Add(new rollingStockAtrributesTable(DataProvider));
DataProvider.Schema.Tables.Add(new LocationsTable(DataProvider));
DataProvider.Schema.Tables.Add(new ConsigneeShipperTable(DataProvider));
DataProvider.Schema.Tables.Add(new BillOfLadingPathTable(DataProvider));
DataProvider.Schema.Tables.Add(new RollingStockTable(DataProvider));
}
#endregion
}
public DbQueryable([NotNull] IQueryable dbSet)
{
_inner = dbSet;
Provider = new DbQueryProvider(_inner.Provider);
}
