C# (CSharp) Dapper.Net.Patterns.Syntax.SqlGrammar Examples

Example #1

File: SqlUpdate.cs Project: roe0901/redishelper

 public override string ToSql() => $"{S.Update} {G.Top(TopRaw)} {TableRaw.ToSql()} {G.Clause(SetRaw)} {G.Clause(FromRaw)} {G.Clause(WhereRaw)}".TrimSqueeze();

Example #2

File: SqlCondition.cs Project: roe0901/redishelper

 public override string ToSql() => $"{G.Not(IsInvertedRaw)} {ExpressionRaw.ToSql()} {G.And(AndRaw)} {G.Or(OrRaw)}".TrimSqueeze();

Example #3

File: SqlDelete.cs Project: koder101/dapper-net

 public override string ToSql() => $"{S.Delete} {G.Top(TopRaw)} {FromRaw.ToSql()} {G.Clause(WhereRaw)}";

Example #4

File: SqlOn.cs Project: koder101/dapper-net

 public override string ToSql() => $"{S.On} {G.Clause(ConditionRaw)}".TrimSqueeze();

Example #5

File: SqlInsert.cs Project: roe0901/redishelper

 public override string ToSql() => $"{S.Insert} {G.Top(TopRaw)} {S.Into} {TableRaw.ToSql()} ({ColumnsRaw}) {G.Values(ValuesRaw)}";

Example #6

File: SqlFrom.cs Project: roe0901/redishelper

 public override sealed string ToSql() => $"{S.From} {TableRaw.ToSql()} {G.NoLock(NoLockRaw)} {G.Clause(JoinRaw)}".TrimSqueeze();

Example #7

 public override string ToSql() => $"{G.Join(DirectionRaw)}  {On(OnRaw)} {G.Clause(JoinRaw)}".TrimSqueeze();