Exemplos de SampleLinq2SqlUnitTesting LinqDataClassesDataContext.ExecuteQuery em C# (CSharp)

Exemplo n.º 1

 public List <Department> GetAllDepartments()
 {
     using (var db = new LinqDataClassesDataContext(DatabaseConnectionString.Get()))
     {
         return(db.ExecuteQuery <Department>("exec AllDepartments").ToList());
     }
 }

Exemplo n.º 2

 public string StripWWWAndCom(string url)
 {
     using (var db = new LinqDataClassesDataContext(DatabaseConnectionString.Get()))
     {
         return(db.ExecuteQuery <string>($"SELECT dbo.StripWWWandCom('{url}')").FirstOrDefault());
     }
 }