public ChannelDTO FindByID(string id)
{
using (var connection = DapperFactory.GetOpenConnection())
{
return(connection.Get <ChannelDTO>(id));
}
}
public void Update(FiosStation obj)
{
using (var connection = DapperFactory.GetOpenConnection())
{
connection.Update <FiosStation>(obj);
}
}
public void Remove(FiosStation obj)
{
using (var connection = DapperFactory.GetOpenConnection())
{
connection.Delete <FiosStation>(obj);
}
}
public IEnumerable <FiosStation> GetAll()
{
using (var connection = DapperFactory.GetOpenConnection())
{
return(connection.GetAll <FiosStation>());
}
}
public FiosStation FindByID(string id)
{
using (var connection = DapperFactory.GetOpenConnection())
{
return(connection.Get <FiosStation>(id));
}
}
public long Add(FiosStation obj)
{
using (var connection = DapperFactory.GetOpenConnection())
{
return(connection.Insert <FiosStation>(obj));
}
}
public IEnumerable <ChannelDTO> GetAll()
{
var query = getQuery(this._version).Replace("*", "a.strFIOSServiceId");
using (var connection = DapperFactory.GetOpenConnection())
{
return(connection.Query <ChannelDTO>(query.ToString()));
}
}