public void To_String() { IAlias person = sql.Alias("dbo.person"); IFrom from = sql.From(person); Assert.Equal("FROM dbo.person", from.ToString()); }
public void To_String_Subquery() { IAlias person = sql.Alias("person"); IFrom from = sql.From(sql.RawQuery("Subquery"), person); Assert.Equal("FROM (Subquery) AS person", from.ToString()); }
// twin method internal static FromChainer From(this IFrom prev, IOpenView table, DbNode node) { var cfrom = new FromChainer((Chainer)prev, table); cfrom.SetNode(node); return(cfrom); }
public void To_String_Typed_Alias() { IAlias <Person> person = sql.Alias <Person>(); IFrom from = sql.From(person); Assert.Equal("FROM Person AS person", from.ToString()); }
public void To_String_Options() { IAlias person = sql.Alias("person"); IFrom from = sql.From(person).Options(sql.Raw("WITH (NO LOCK)")); Assert.Equal("FROM person WITH (NO LOCK)", from.ToString()); }
public void WriteFragment_Parentheses() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b.WriteFragment(from, true)); Assert.Equal("(FROM person)", result); }
public void To_String_Typed_Alias_With_Alias_Name() { IAlias <Person2> person = sql.Alias <Person2>("per"); IFrom from = sql.From(person); Assert.Equal("FROM Person2 AS per", from.ToString()); }
public void AliasOrTableName_Property_Alias_Name() { IAlias person = sql.Alias("dbo.person", "per"); IFrom from = sql.From(person); Assert.Equal("per", from.AliasOrTableName); }
public void WriteValue_Fragment() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b.WriteValue(from)); Assert.Equal("FROM person", result); }
public void To_String_With_Alias_Name() { IAlias person = sql.Alias("dbo.person", "per"); IFrom from = sql.From(person); Assert.Equal("FROM dbo.person AS per", from.ToString()); }
public void From_Subquery_String() { IFrom from = sql.From(sql.RawQuery("Subquery"), "sub"); QueryResult result = engine.Compile(from); Assert.Equal("FROM (Subquery) AS \"sub\"", result.Sql); }
public void IfNotNull_Null_Value() { IFrom from = null; string result = ToStringBuilder.Build(b => b .IfNotNull(from, (x) => b.WriteFragment(x))); Assert.Equal("", result); }
public void IfNotNull_Delegate_Without_Value_Null_Value() { IFrom from = null; string result = ToStringBuilder.Build(b => b .IfNotNull(from, () => b.WriteFragment(from))); Assert.Equal("", result); }
public void IfNot_True() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b .IfNot(from == null, () => b.WriteFragment(from))); Assert.Equal("FROM person", result); }
public void IfNot_False() { IFrom from = null; string result = ToStringBuilder.Build(b => b .IfNot(from == null, () => b.WriteFragment(from))); Assert.Equal("", result); }
public void From_String() { IFrom from = sql.From("dbo.person"); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"dbo\".\"person\"", result.Sql); }
public void IfNotNull() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b .IfNotNull(from, (x) => b.WriteFragment(x))); Assert.Equal("FROM person", result); }
public void From_String_With_Alias_Name() { IFrom from = sql.From("dbo.person", "per"); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"dbo\".\"person\" AS \"per\"", result.Sql); }
public void IfNotNull_Delegate_Without_Value() { IFrom from = sql.From("person"); string result = ToStringBuilder.Build(b => b .IfNotNull(from, () => b.WriteFragment(from))); Assert.Equal("FROM person", result); }
public void From_Typed_Alias() { IAlias <Person> person = sql.Alias <Person>(); IFrom from = sql.From(person); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"Person\" AS \"person\"", result.Sql); }
public void From_Subquery_Expression() { Person person = null; IFrom from = sql.From(sql.RawQuery("Subquery"), () => person); QueryResult result = engine.Compile(from); Assert.Equal("FROM (Subquery) AS \"person\"", result.Sql); }
public void From_Expression() { Person2 person = null; IFrom from = sql.From(() => person); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"dbo\".\"Person\" AS \"person\"", result.Sql); }
public void From_Typed_Alias_With_Alias_Name() { IAlias <Person2> person = sql.Alias <Person2>("per"); IFrom from = sql.From(person); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"dbo\".\"Person\" AS \"per\"", result.Sql); }
public void From_Alias() { IAlias person = sql.Alias("dbo.person"); IFrom from = sql.From(person); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"dbo\".\"person\"", result.Sql); }
public void Options() { Person person = null; IFrom from = sql.From(() => person).Options(sql.Raw("WITH (NO LOCK)")); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"Person\" AS \"person\" WITH (NO LOCK)", result.Sql); }
public void From_Alias_With_Alias_Name() { IAlias person = sql.Alias("person", "per"); IFrom from = sql.From(person); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"person\" AS \"per\"", result.Sql); }
public void From_Subquery_Alias() { IAlias person = sql.Alias("person"); IFrom from = sql.From(sql.RawQuery("Subquery"), person); QueryResult result = engine.Compile(from); Assert.Equal("FROM (Subquery) AS \"person\"", result.Sql); }
public InnerJoin(IFrom thisEntity, Attribute thisJoinAttr, IFrom joinedEntity, Attribute joinedAttr, string alias = null) { _thisEntity = thisEntity; _thisJoinAttr = thisJoinAttr; _joinedEntity = joinedEntity; _joinedAttr = joinedAttr; _alias = alias; }
public void From_Cte_String() { IAlias person = sql.Alias("person"); ICte cte = sql.Cte("cte").As(sql.Query.Select(person.All).From(person)); IFrom from = sql.From(cte, "personCte"); QueryResult result = engine.Compile(from); Assert.Equal("FROM \"cte\" AS \"personCte\"", result.Sql); }
public SelectFrom <TSelectedColumns> From(IFrom from) { if (this.FromNode != null) { throw new ApplicationException(); } QueryNodeHelper.SwitchParent(from, this); this.FromNode = from; return(this); }
public TSelect(StringBuilder sb,IFrom tf,IWhere tw) { this.sql = sb; this.tfrom = tf; this.twhere = tw; }
public TSelect() { sql = new StringBuilder(); twhere = new TWhere(sql); tfrom = new TFrom(sql); }
public TUpdate() { this.sql = new StringBuilder(); tfrom = new TFrom(sql); this.twhere = new TWhere(sql); }
public TUpdate(StringBuilder sb) { this.sql = sb; tfrom = new TFrom(sql); this.twhere = new TWhere(sql); }
public TDelete() { sql = new StringBuilder(); tfrom = new TFrom(sql); }
public TDelete(StringBuilder sb) { this.sql = sb; tfrom = new TFrom(sql); }