C# (CSharp) SplitColumns Examples

Example #1

File: SqlQueryBuilderSpec.cs Project: Mutuduxf/Zaabee.Dapper

        public void Join(string originalTableName, string joinTableName, string leftField, string rightField)
        {
            var joinString =
                $"JOIN {Adapter.Table(joinTableName)} ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
            SplitColumns.Add(rightField);
        }

Example #2

File: SqlQueryBuilder_SelectStatements.cs Project: tofilagman/Dapper.SqlBuilder

        public void Join(string originalTableName, string joinTableName, string leftField, string rightField, JoinType joinType)
        {
            var join       = GetJoinExpression(joinType);
            var joinString =
                $"{join} {Adapter.Table(joinTableName)} " +
                $"ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
            SplitColumns.Add(rightField);
        }