C# (CSharp) FluentDbTools.SqlBuilder.Common SqlBuilderHelper.GetAliasForType Examples

Example #1

File: SelectFieldSelector.cs Project: radtek/FluentDbTools

        public ISelectFieldSelector <TClass> F(string field, string alias = null, string tablealias = null)
        {
            var tableAlias = SqlBuilderHelper.GetAliasForType <TClass>(tablealias);

            AddTableAlias(tableAlias);

            if (string.IsNullOrEmpty(alias))
            {
                FieldsList.Add($"{tableAlias}.{field}");
            }
            else
            {
                FieldsList.Add($"{tableAlias}.{field} as {alias}");
            }

            return(this);
        }

Example #2

File: WhereFieldSelectorWithSelect.cs Project: radtek/FluentDbTools

 private string GetAliasForType()
 {
     return(Prefix ?? SqlBuilderHelper.GetAliasForType <TClass>());
 }