C# (CSharp) Check.ServiceInterface NamedConnection Examples

Example #1

File: NamedConnectionService.cs Project: 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;
         }
     }
 }

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