public CustomerSearch(ISqlDb db) : base(
@"SELECT * FROM [dbo].[Customer]
WHERE
[OrganizationId]=@orgId AND
([LastName] LIKE '%' + @search + '%' OR [FirstName] LIKE '%' + @search + '%')" , db)
{
}
public OrganisationRepository(ISqlDb sqlDb)
{
this.sqlDb = sqlDb;
}
public IEnumerable <TResult> Execute(ISqlDb db, int pageNumber = 0)
{
Db = db;
return(Execute(pageNumber));
}
public Query(string sql, ISqlDb db)
{
_sql = sql;
_db = db;
}
public TResult ExecuteSingle(ISqlDb db)
{
Db = db;
return(ExecuteSingle());
}
public BeerData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public CoffeeData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public VinylData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public ActivityData(ISqlDb dataAccess)
{
_dataAccess = dataAccess;
}
public SiteData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public HolidayData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public IdentityData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public GetData(ISqlDb dataAccess)
{
_dataAccess = dataAccess;
}
public PeopleData(ISqlDb db)
{
_db = db;
}
public TestAttachWhereQuery(ISqlDb db) : base("SELECT * FROM [TableA] {where}", db)
{
}
public FoodData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
public FilmData(ISqlDb dataAccess
)
{
_dataAccess = dataAccess;
}
