static void Main(string[] args)
{
// TODO get from config
const string connectionString = "";
ISqlServerEngineSpecifications sqlServerEngineSpecifications = new SqlServerEngineSpecifications(connectionString);
IFooRepository fooRepository = new FooSqlServerDapperRepository(sqlServerEngineSpecifications);
}
public Foo GetByName(string name)
{
Foo fooToReturn;
using (var cn = SqlServerEngineSpecifications.CreateAndOpenConnection())
{
const string getByNameQuery = "select m.Id, m.Name " +
"where m.Name = @Name;";
var getByNameParams = new { Name = name };
fooToReturn = cn.Query <Foo>(getByNameQuery, getByNameParams)
.FirstOrDefault();
}
return(fooToReturn);
}
