1 <#@ include file="OrmLite.Core.ttinclude" #>
4 ConnectionStringName = ""; // Uses last connection string in config if not specified
5 var SPNamespace = "StoredProcedures";
17 if (string.IsNullOrEmpty(SPNamespace)) SPNamespace=ConnectionStringName;
18 if (string.IsNullOrEmpty(SPNamespace)) SPNamespace="StoredProcedures";
21 using System.Data.Common;
23 using System.Collections.Generic;
24 using ServiceStack.OrmLite;
26 namespace <#=SPNamespace#>
28 public static class SPList
30 private static DbParameter CreateNewParameter(DbCommand dbCommand, string paramName, object paramValue, ParameterDirection paramDirection, DbType paramType)
32 DbParameter param = dbCommand.CreateParameter();
33 param.Direction = paramDirection;
34 param.DbType = paramType;
35 param.ParameterName = paramName;
36 param.Value = paramValue;
40 <#foreach(var sp in sps){#>
41 public static OrmLiteSPStatement <#=sp.CleanName#>(this IDbConnection db<#foreach(var param in sp.Parameters){#>, <#=param.NullableSysType#> <#=Inflector.MakeInitialLowerCase(param.Name)#> = null<#}#>)
43 var dbCmd = (DbCommand)OrmLiteConfig.ExecFilter.CreateCommand(db).ToDbCommand();
44 dbCmd.CommandText = "<#=sp.Name#>";
45 dbCmd.CommandType = CommandType.StoredProcedure;
46 <#if (sp.Parameters.Count > 0) { foreach(var param in sp.Parameters){#>
47 dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"<#=param.Name#>",<#=Inflector.MakeInitialLowerCase(param.Name)#>,ParameterDirection.Input,<#=param.DbType#>));
49 return new OrmLiteSPStatement(db, dbCmd);