public List <Department> GetAllDepartments()
{
using (var db = new LinqDataClassesDataContext(DatabaseConnectionString.Get()))
{
return(db.ExecuteQuery <Department>("exec AllDepartments").ToList());
}
}
public string StripWWWAndCom(string url)
{
using (var db = new LinqDataClassesDataContext(DatabaseConnectionString.Get()))
{
return(db.ExecuteQuery <string>($"SELECT dbo.StripWWWandCom('{url}')").FirstOrDefault());
}
}
public List <string> GetAllEmployeeNames()
{
using (var db = new LinqDataClassesDataContext(DatabaseConnectionString.Get()))
{
var result = (from e in db.Employees select e.LastName + ", " + e.FirstName).ToList();
return(result);
}
}