.class[SqlConnection] conn = new .class[SqlConnection]("..."); .class[SqlCommand] cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * FROM Customer WHERE City = @CityParam"; cmd.Parameters.Add("@CityParam", "Paris"); .class[SqlDataReader] r = cmd.ExecuteReader(); while ( r.HasRows ) { .class[Console].WriteLine(r["Address"] + r["City"]); }
.class[Northwind] db = new .class[Northwind](connectString); .interface[IQueryable] <.class[Customer]> query = db.Customers.Where(cust=>cust.City == "Paris"); foreach(var cust in query) { .class[Console].WriteLine(cust.Address + cust.City); }
var query = from cust in db.Customers where cust.City == "Paris" select new {cust.Address, cust.City};
var query = db.Customers.Where(cust=>cust.City == "Paris") .Select(new {cust.Address, cust.City});
.class[List]<.class[int]> newList = new .class[List]<.class[int]>(); foreach( var item in lists){ newList.Add(item); }
.interface[Ienumerable]<.class[int]> query = from list in lists from item in list select num; .class[List]<.class[int]> newList = query.ToList();
.class[SqlConnection] conn = new .class[SqlConnection]("..."); .class[SqlCommand] cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT * FROM Customer"; .class[SqlDataReader] r = cmd.ExecuteReader();
.class[List]<.class[Customer]> query = db.Customers.ToList();
.interface[IQueryable]<.class[Customer]> query = db.Customers.Where(cust=>cust.City == "London");
.interface[IQueryable]<.class[Customer]> query2 = query.Where(cust=>cust.Address.StartsWith("221b"));
var query = new .class[XElement]("Order", db.Customers.Where(cust=>cust.City == "Paris") .Select(cust=> new .class[XElement]("Order", new .class[XAttribute]("Address", cust.Address), new .class[XAttribute]("City", cust.City))));
return new .class[UserDto]();
.interface[IQueryable] <.class[User]> query = this.context.Users; return this.mapper.Map <.class[List]<.class[UserDto]>> (query.ToList());
.interface[IQueryable] <.class[User]> query = this.context.Users.Where(usr => usr.Id.Equals(id)); .class[User] user = query.FirstOrDefault(); return this.mapper.Map<.class[UserDto]>(user);
.class[Func]<.class[TestDbContext], .class[User]> QueryUserById = EF.CompileQuery( context => context.Users.FirstOrDefault(usr => usr.Id.Equals(id))); .class[User] user = QueryUserById(this.context); return this.mapper.Map <.class[UserDto]> (user);