simple DAO with Entlib DAAB

gistfile1.cs

public class ListingsGridDao{
	private const string QueryListings = "query with parameters @advertiserId";
	private const string QueryReportListings = "query with parameters @advertiserId, @startDate, @endDate";
	
	public IEnumerable<Listing> GetListings(int advertiserId){
		var db = DatabaseFactory.CreateDatabase(ConfigurationManager.AppSettings["DBReportsCRUD"]);
		List<Listing> result = new List<Listing>();
		using(var cmd = db.GetSqlStringCommand(QueryListings)){
			db.AddInParameter(cmd, "@advertiserId", DbType.Int,advertiserId );
			using(var reader = db.ExecuteReader(cmd)){
				while(reader.Read()){
					result.Add(
						new Listing{ 
							Id = Convert.ToInt32(reader["profile_id"])
						}
					);
				}
				if(result.Count()<=0) throw new InvalidOperationException("Listings not loaded... ");
			}			
		}
	}
	
	public IEnumerable<ReportListing> GetReportListings(int advertiserId, string startDate, string endDate){
	
	}
}