C# (CSharp) Check.ServiceInterface NamedConnection示例

示例#1

文件： NamedConnectionService.cs 项目： AVee/ServiceStack

 public object Any(NamedConnection request)
 {
     using (var db = ConnectionFactory.OpenDbConnection("SqlServer"))
     {
         using (var cmd = db.SqlProc(
             "GetUserIdsFromEmailAddresses", new {request.EmailAddresses}))
         {
             var userIds = cmd.ConvertToList<int>();
             return userIds;
         }
     }
 }

示例#2

 public object Any(NamedConnection request)
 {
     using (var db = DbFactory.OpenDbConnection("SqlServer"))
     {
         using (var cmd = db.SqlProc(
                    "GetUserIdsFromEmailAddresses", new { request.EmailAddresses }))
         {
             var userIds = cmd.ConvertToList <int>();
             return(userIds);
         }
     }
 }