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());
}
}
