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