Search Results for

    Show / Hide Table of Contents
    View Source

    Class NPocoSqlExtensions.Statics

    Provides a mean to express aliases in SELECT Sql statements.

    Inheritance
    System.Object
    Namespace: Umbraco.Core.Persistence
    Assembly: Umbraco.Core.dll
    Syntax
    public static class Statics
    Remarks

    First register with using static Umbraco.Core.Persistence.NPocoSqlExtensions.Aliaser, then use eg Sql{Foo}(x => Alias(x.Id, "id")).

    Methods

    View Source

    Alias(Object, String)

    Aliases a field.

    Declaration
    public static object Alias(object field, string alias)
    Parameters
    Type Name Description
    System.Object field

    The field to alias.

    System.String alias

    The alias.

    Returns
    Type Description
    System.Object
    View Source

    SqlText<T>(String, Func<String, String>)

    Produces Sql text.

    Declaration
    public static T SqlText<T>(string field, Func<string, string> expr)
    Parameters
    Type Name Description
    System.String field

    The name of the field.

    System.Func<System.String, System.String> expr

    A function producing Sql text.

    Returns
    Type Description
    T
    Type Parameters
    Name Description
    T
    View Source

    SqlText<T>(String, String, Func<String, String, String>)

    Produces Sql text.

    Declaration
    public static T SqlText<T>(string field1, string field2, Func<string, string, string> expr)
    Parameters
    Type Name Description
    System.String field1

    The name of the first field.

    System.String field2

    The name of the second field.

    System.Func<System.String, System.String, System.String> expr

    A function producing Sql text.

    Returns
    Type Description
    T
    Type Parameters
    Name Description
    T
    View Source

    SqlText<T>(String, String, String, Func<String, String, String, String>)

    Produces Sql text.

    Declaration
    public static T SqlText<T>(string field1, string field2, string field3, Func<string, string, string, string> expr)
    Parameters
    Type Name Description
    System.String field1

    The name of the first field.

    System.String field2

    The name of the second field.

    System.String field3

    The name of the third field.

    System.Func<System.String, System.String, System.String, System.String> expr

    A function producing Sql text.

    Returns
    Type Description
    T
    Type Parameters
    Name Description
    T
    • Improve this Doc
    • View Source
    In This Article
    • Methods
      • Alias(Object, String)
      • SqlText<T>(String, Func<String, String>)
      • SqlText<T>(String, String, Func<String, String, String>)
      • SqlText<T>(String, String, String, Func<String, String, String, String>)
    Back to top Copyright © 2016-present Umbraco
    Generated by DocFX