C# (CSharp) SqlFunctions.Add Exemples

Exemple #1

Fichier : SqlCeFunctionRegistry.cs Projet : 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"));
 }

Exemple #2

Fichier : SQLiteFunctionManager.cs Projet : 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"));
 }

Exemple #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"));
 }

Exemple #4

Fichier : AccessFunctionRegistry.cs Projet : 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"));
 }

Exemple #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"));
 }

Exemple #6

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