SqlParser.cs
/// <summary>
/// Stringify comming column Expressions into sql where clause string 
/// </summary>
/// <param name="sqlColumnsNamesMapSorting"></param>
/// <returns></returns>
Stringify comming column Expressions into sql where clause string
Stringify comming column Expressions into sql where clause string
public string StringifyColumnSortExpressions(Dictionary<string, string> sqlColumnsNamesMapSorting)
		{
			this.sqlColumnsMap = sqlColumnsNamesMapSorting;
			var fullColumnSortExpressionsString = string.Empty;
			var columnSortOptionsStringList = new List<string>();
			if (columnSortExpressions != null)
			{
				foreach (var sortOption in columnSortExpressions)
				{
					var colName = this.GetSQLColumnName(sortOption.ColumnName);
					if (!string.IsNullOrWhiteSpace(colName))
					{
						columnSortOptionsStringList.Add($"{colName} {sortOption.OrderType}");
					}
				}
			}
			fullColumnSortExpressionsString = $" {string.Join(",", columnSortOptionsStringList)}";
			return  $" {fullColumnSortExpressionsString} ";
		}
public string StringifyColumnSortExpressions ( Dictionary < string , string > sqlColumnsNamesMapSorting ) { this . sqlColumnsMap = sqlColumnsNamesMapSorting ; var fullColumnSortExpressionsString = string . Empty ; var columnSortOptionsStringList = new List < string > ( ) ; if ( columnSortExpressions != null ) { foreach ( var sortOption in columnSortExpressions ) { var colName = this . GetSQLColumnName ( sortOption . ColumnName ) ; if ( ! string . IsNullOrWhiteSpace ( colName ) ) { columnSortOptionsStringList . Add ( $" { colName } { sortOption . OrderType } " ) ; } } } fullColumnSortExpressionsString = $" { string . Join ( " " , columnSortOptionsStringList ) } " ; return $" { fullColumnSortExpressionsString } " ; }
Stringify comming column Expressions into sql where clause string
Stringify comming column Expressions into sql where clause string
None
sqlColumnsNamesMapSorting
Dictionary<string, string>
None