public static ITableConfig Table(this IConfig config, Type tableType, TableFlags?flags = null) { var selector = TableConfig.By(tableType, flags); var table = config.GetTable(selector); if (table == null) { table = config.CreateTable(selector); } return(table); }
protected virtual bool TryGetTable(Expression expression, out ITableConfig result) { var type = expression.Type; if (type.IsGenericType) { type = type.GetGenericArguments()[0]; } result = this.Database.Config.GetTable(TableConfig.By(type)); return(result != null); }
protected virtual bool TryGetTable(MemberInfo member, out ITableConfig result) { var type = this.GetMemberType(member); if (type.IsGenericType) { result = default(ITableConfig); return(false); } result = this.Database.Config.GetTable(TableConfig.By(type)); return(result != null); }
public static ITableConfig <T1, T2> Table <T1, T2>(this IConfig config, TableFlags?flags = null) { var leftTable = config.Table <T1>(flags); var rightTable = config.Table <T2>(flags); var selector = TableConfig.By(leftTable, rightTable, flags); var table = config.GetTable(selector); if (table == null) { table = config.CreateTable(selector); } return(table as ITableConfig <T1, T2>); }
public void CommonTableExpression_1() { switch (this.ProviderType) { case ProviderType.SqlCe: Assert.Ignore("The provider does not support common table expressions."); return; } var set = this.Database.Set <Test002>(this.Transaction); var data = new List <Test002>(); set.Clear(); set.AddRange(new[] { new Test002() { Name = "1" }, new Test002() { Name = "2" }, new Test002() { Name = "3" } }); var query = this.Database.QueryFactory.Build(); var subQuery = this.Database.QueryFactory.Build(); subQuery.Output.AddOperator(QueryOperator.Star); subQuery.Source.AddTable(set.Table); subQuery.Filter.AddColumn( set.Table.GetColumn(ColumnConfig.By("Name")) ).Right = query.Filter.CreateConstant("2"); query.With.AddCommonTableExpression(new[] { subQuery, subQuery }).Alias = "Extent1"; query.Output.AddOperator(QueryOperator.Star); query.Source.AddTable( this.Database.Config.Transient.CreateTable( TableConfig.By("Extent1", TableFlags.None) ) ); set.Fetch = query; foreach (var item in set) { Assert.AreEqual("2", item.Name); } }
protected virtual bool TryGetColumn(MemberInfo member, Expression expression, out IColumnConfig result) { var property = member as PropertyInfo; if (property == null) { result = default(IColumnConfig); return(false); } var table = this.Database.Config.GetTable(TableConfig.By(expression.Type)); if (table == null) { result = default(IColumnConfig); return(false); } result = table.GetColumn(ColumnConfig.By(property)); return(result != null); }
protected virtual bool TryGetRelation(MemberInfo member, Expression expression, out IRelationConfig result) { var type = this.GetMemberType(member); if (type.IsGenericType) { type = type.GetGenericArguments()[0]; } var table = this.Database.Config.GetTable(TableConfig.By(expression.Type)); if (table != null) { foreach (var relation in table.Relations) { if (relation.RelationType == type) { result = relation; return(true); } } } result = default(IRelationConfig); return(false); }
public void ExpressionDependency_A() { this.Database.Config.CreateTable(TableConfig.By(typeof(A), TableFlags.None)).With(a => { a.Column("Id", ColumnFlags.None).IsPrimaryKey = true; a.Column("B_Id", ColumnFlags.None).IsForeignKey = true; }); this.Database.Config.CreateTable(TableConfig.By(typeof(B), TableFlags.None)).With(b => { b.Column("Id", ColumnFlags.None).IsPrimaryKey = true; b.Column("A_Id", ColumnFlags.None).IsForeignKey = true; b.Column("C_Id", ColumnFlags.None).IsForeignKey = true; }); this.Database.Config.CreateTable(TableConfig.By(typeof(C), TableFlags.None)).With(c => { c.Column("Id", ColumnFlags.None).IsPrimaryKey = true; c.Column("B_Id", ColumnFlags.None).IsForeignKey = true; c.Column("D_Id", ColumnFlags.None).IsForeignKey = true; }); this.Database.Config.CreateTable(TableConfig.By(typeof(D), TableFlags.None)).With(d => { d.Column("Id", ColumnFlags.None).IsPrimaryKey = true; d.Column("A_Id", ColumnFlags.None).IsForeignKey = true; d.Column("C_Id", ColumnFlags.None).IsForeignKey = true; }); this.Database.Config.Table <A>().With(a => { a.Relation(item => item.B).With(relation => { relation.Expression = relation.CreateConstraint().With(constraint => { constraint.Left = relation.CreateConstraint( this.Database.Config.Table <B>().Column("Id"), this.Database.Config.Table <A>().Column("B_Id") ); constraint.Left = relation.CreateConstraint( this.Database.Config.Table <A>().Column("Id"), this.Database.Config.Table <B>().Column("A_Id") ); }); }); a.Relation(item => item.D).With(relation => { relation.Expression = relation.CreateConstraint( this.Database.Config.Table <A>().Column("Id"), this.Database.Config.Table <D>().Column("A_Id") ); }); }); this.Database.Config.Table <B>().With(b => { b.Relation(item => item.C).With(relation => { relation.Expression = relation.CreateConstraint( this.Database.Config.Table <C>().Column("Id"), this.Database.Config.Table <B>().Column("C_Id") ); }); }); this.Database.Config.Table <C>().With(c => { c.Relation(item => item.D).With(relation => { relation.Expression = relation.CreateConstraint( this.Database.Config.Table <D>().Column("Id"), this.Database.Config.Table <C>().Column("D_Id") ); }); }); var composer = new EntityRelationQueryComposer(this.Database, this.Database.Config.Table <A>()); var relations = composer.Fetch.RelationManager.CalculatedRelations; var query = composer.Fetch.Build(); }
public void OneTimeSetUp() { var provider = this.CreateProvider(); try { provider.DeleteDatabase(this.InitialCatalog); } catch { //Nothing to do. } provider.CreateDatabase(this.InitialCatalog); this.Database = this.CreateDatabase(); var tables = new[] { this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test001), TableFlags.AutoColumns | TableFlags.AutoIndexes) ).With(table => { table.CreateColumn(ColumnConfig.By("Field4", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Int32, isNullable: true)); }); table.CreateColumn(ColumnConfig.By("Field5", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Double, isNullable: true)); }); }), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test003), TableFlags.AutoColumns | TableFlags.AutoIndexes) ).With(table => { table.CreateColumn(ColumnConfig.By("Test002_Id", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Int32, isNullable: true)); }); }), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test004), TableFlags.AutoColumns | TableFlags.AutoIndexes) ).With(table => { table.CreateColumn(ColumnConfig.By("Test002_Id", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Int32, isNullable: true)); }); }), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test002), TableFlags.AutoColumns | TableFlags.AutoIndexes | TableFlags.AutoRelations) ).With(table => { table.CreateColumn(ColumnConfig.By("Version", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Binary, size: 8, isNullable: true)); }); }), this.Database.Config.Transient.CreateTable( TableConfig.By( this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test002), TableFlags.AutoColumns) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test004), TableFlags.AutoColumns) ), TableFlags.AutoColumns | TableFlags.AutoRelations ) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test005), TableFlags.AutoColumns | TableFlags.AutoIndexes) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test006), TableFlags.AutoColumns | TableFlags.AutoIndexes) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test008), TableFlags.AutoColumns | TableFlags.AutoIndexes) ).With(table => { table.CreateColumn(ColumnConfig.By("Test007_Id", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Guid, isNullable: true)); }); }), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test009), TableFlags.AutoColumns | TableFlags.AutoIndexes) ).With(table => { table.CreateColumn(ColumnConfig.By("Test007_Id", ColumnFlags.None)).With(column => { column.ColumnType = Factories.Type.Create(TypeConfig.By(DbType.Guid, isNullable: true)); }); }), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test007), TableFlags.AutoColumns | TableFlags.AutoIndexes | TableFlags.AutoRelations) ), this.Database.Config.Transient.CreateTable( TableConfig.By( this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test007), TableFlags.AutoColumns) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test009), TableFlags.AutoColumns) ), TableFlags.AutoColumns | TableFlags.AutoRelations ) ) }; foreach (var table in tables) { var query = this.Database.SchemaFactory.Add(table, Defaults.Schema.Flags).Build(); this.Database.Execute(query); this.Database.Schema.Reset(); } }
public void OneTimeTearDown() { var tables = new[] { this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test001), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By( this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test002), TableFlags.AutoColumns) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test004), TableFlags.AutoColumns) ), TableFlags.AutoColumns | TableFlags.AutoRelations ) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test003), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test004), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test002), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test005), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test006), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By( this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test007), TableFlags.AutoColumns) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test009), TableFlags.AutoColumns) ), TableFlags.AutoColumns | TableFlags.AutoRelations ) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test008), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test009), TableFlags.None) ), this.Database.Config.Transient.CreateTable( TableConfig.By(typeof(Test007), TableFlags.None) ) }; foreach (var table in tables) { var query = this.Database.SchemaFactory.Delete(table, Defaults.Schema.Flags).Build(); this.Database.Execute(query); this.Database.Schema.Reset(); } this.Database.Dispose(); this.Database = null; }