Exemplos de SqlFunctions.Add em C# (CSharp)

Exemplo n.º 1

Arquivo: SqlCeFunctionRegistry.cs Projeto: shumtn/skynet-cloud

 public SqlCeFunctionRegistry()
 {
     // SqlFunctions.Add(FunctionType.ToString, FunctionViews.VarArgs("CONVERT(NVARCHAR,", ",", ")"));
     SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
     SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("NewID"));
     SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("DataLength"));
 }

Exemplo n.º 2

Arquivo: SQLiteFunctionManager.cs Projeto: yinmin/elinq

 public SQLiteFunctionManager()
 {
     SqlFunctions.Add(FunctionType.Case, FunctionView.Case);
     //SqlFunctions.Add(FunctionType.ToString, FunctionViews.Proxy((v, args) => v.Visit(args[0])));
     SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
     SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("NewID"));
     SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Length"));
 }

Exemplo n.º 3

 public MySqlFunctionRegistry()
 {
     SqlFunctions.Add(FunctionType.Case, FunctionView.Case);
     //SqlFunctions.Add(FunctionType.ToString, FunctionViews.VarArgs("CAST(", ",", " AS CHAR)"));
     SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
     SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("Uuid"));
     SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Length"));
 }

Exemplo n.º 4

Arquivo: AccessFunctionRegistry.cs Projeto: shumtn/skynet-cloud

 public AccessFunctionRegistry()
 {
     SqlFunctions.Add(FunctionType.Case, new IFFunctionView());
     // SqlFunctions.Add(FunctionType.ToString, FunctionViews.StandardSafe("cstr", 1));
     SqlFunctions.Add(FunctionType.Compare, CompareFunctionView.Instance);
     SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("newID"));
     SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("len"));
 }

Exemplo n.º 5

 public OracleFunctionRegistry()
 {
     SqlFunctions.Add(FunctionType.Case, FunctionView.Case);
     //SqlFunctions.Add(FunctionType.ToString, FunctionViews.VarArgs("CONVERT(NVARCHAR,", ",", ")"));
     SqlFunctions.Add(FunctionType.Compare, FunctionView.Compare);
     SqlFunctions.Add(FunctionType.ToChar, FunctionView.Standard("to_char"));
     SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("Sys_Guid"));
     SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Length"));
 }

Exemplo n.º 6

 public FirebirdFunctionRegistry()
 {
     SqlFunctions.Add(FunctionType.NewGuid, FunctionView.Standard("Gen_Uuid"));
     SqlFunctions.Add(FunctionType.Length, FunctionView.Standard("Octet_Length"));
 }