public IEnumerable <City> GetCities(string cityName)
{
var results = new List <City>();
using (var context = new WorldWideImporters())
{
context.Database.Log = message => Log.Debug(message);
var cityNameParameter = new SqlParameter()
{
ParameterName = "@cityName"
};
if (string.IsNullOrWhiteSpace(cityName))
{
cityNameParameter.Value = DBNull.Value;
}
else
{
cityNameParameter.Value = cityName;
}
results = context.Database.SqlQuery <City>("dbo.SearchCities @cityName", cityNameParameter).ToList();
}
return(results);
}
public IEnumerable <Person> GetPeople()
{
var results = new List <Person>();
using (var context = new WorldWideImporters())
{
context.Database.Log = message => Log.Debug(message);
results = context.Database.SqlQuery <Person>("dbo.GetPeople").ToList();
}
return(results);
}
public IEnumerable <City> GetCities()
{
var results = new List <City>();
using (var context = new WorldWideImporters())
{
context.Database.Log = message => Log.Debug(message);
results = context.Database.SqlQuery <City>("dbo.SearchCities").ToList();
}
return(results);
}
