static async Task Sample3Async() { // simple command var q1 = SimpleCommand.ExecuteQueryAsync<Employee>(new ExecutionOptions(fieldsSelector: FieldsSelector.Source), CancellationToken.None, connStr, "select ID, CompanyID, Name, Phone from Employee where CompanyID = @p0", 1); var arr1 = await q1.ToArray(); // mapped command with anonymous type var a = new { CompanyID = 1 }; var q2 = MappedCommand.Compile(a, "select ID, CompanyID, Name, Phone from Employee where CompanyID = @CompanyID") .ExecuteQueryAsync<Employee>(connStr, a, new ExecutionOptions(fieldsSelector: FieldsSelector.Source)); var arr2 = await q2.ToArray(); }
// Using FieldsSelector option: there will only be filled columns contains in source static void Sample3() { // simple command var q1 = SimpleCommand.ExecuteQuery<Employee>(new ExecutionOptions(fieldsSelector: FieldsSelector.Source), connStr, "select ID, CompanyID, Name, Phone from Employee where CompanyID = @p0", 1); var arr1 = q1.ToArray(); // mapped command with anonymous type var a = new { CompanyID = 1 }; var q2 = MappedCommand.Compile(a, "select ID, CompanyID, Name, Phone from Employee where CompanyID = @CompanyID") .ExecuteQuery<Employee>(connStr, a, new ExecutionOptions(fieldsSelector: FieldsSelector.Source)); var arr2 = q2.ToArray(); }
static async Task Sample10Async() { // simple command await SimpleCommand.ExecuteNonQueryAsync(connStr, "update Company set Name = @p1 where ID = @p0", 2, "Updated Co"); // mapped command with anonymous type var a = new { ID = 2, Name = "Updated Co1" }; await MappedCommand.ExecuteNonQueryAsync(connStr, "update Company set Name = @Name where ID = @ID", a); }
// Query without retrieving data static void Sample10() { // simple command SimpleCommand.ExecuteNonQuery(connStr, "update Company set Name = @p1 where ID = @p0", 2, "Updated Co"); // mapped command with anonymous type var a = new { ID = 2, Name = "Updated Co1" }; MappedCommand.ExecuteNonQuery(connStr, "update Company set Name = @Name where ID = @ID", a); }
static async Task Sample8Async() { // simple command var empName1 = await SimpleCommand.ExecuteQueryFirstColumnAsync<string>(connStr, "select Name from Employee where CompanyID = @p0 and Age > @p1", 1, 40).First(); // mapped command with anonymous type var a = new { CompanyID = 1, Age = 40 }; var empName2 = await MappedCommand.Compile(a, "select Name from Employee where CompanyID = @CompanyID and Age > @Age") .ExecuteQueryFirstColumnAsync<string>(connStr, a).First(); }
static async Task Sample6Async() { // simple command var proto = new { Company = default(string), Emp = default(string) }; var q1 = SimpleCommand.ExecuteQueryAnonymousAsync(proto, connStr, "select E.Name as Emp, C.Name as Company from Employee E join Company C on E.CompanyID = C.ID"); var arr1 = await q1.ToArray(); }