UserDevice.cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.Common;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using Dapper;

namespace MetroEShoppingService.Models
{
    public class UserDevice
    {
        public string Id { get; set; }
        public string UserId { get; set; }
        public string DeviceId { get; set; }
        public string ChannelUri { get; set; }
    }

    public class UserDeviceQuery
    {
        private DbConnection connection;
        public UserDeviceQuery(DbConnection connection)
        {
            this.connection = connection;
        }

        public UserDeviceQuery() :
            this(new SqlConnection(ConfigurationManager.ConnectionStrings["MS_TableConnectionString"].ConnectionString))
        {}

        public UserDevice[] GetAll()
        {
            var sql = @"SELECT * FROM UserDevices";
            return connection.Query<UserDevice>(sql).ToArray();
        }
    }
}