克里斯小圭的碎碎念

//基本型
Query MyQuery = Employee.CreateQuery();
MyQuery.AddWhere(Employee.Columns.EmployeeID, "");
MyQuery.AddWhere(Employee.Columns.Address, Comparison.Like, "%");
MyQuery.ORDER_BY(Employee.Columns.EmployeeID + "desc");

EmployeeCollection MyCollection = new EmployeeCollection();
IDataReader rdr = MyQuery.ExecuteReader();
MyCollection.LoadAndCloseReader(rdr);

return MyCollection;

//SQL語法
string sql = "select * from Employee where EmployeeID = @EmployeeID and Address Like @Address order by EmployeeID desc;";
QueryCommand cmd = new QueryCommand(sql);

cmd.AddParameter("@EmployeeID", "");
cmd.AddParameter("@Address", "%");

EmployeeCollection MyCollection = new EmployeeCollection();
IDataReader rdr = DataService.GetReader(cmd);

MyCollection.LoadAndCloseReader(rdr);

return MyCollection;

SqlQuery MyQuery =
 new Select().From<Employee>()
 .Where("EmployeeID").IsEqualTo("")
 .And("Address").Like("%")
 .OrderDesc(new string[] { "EmployeeID" });

EmployeeCollection MyCollection = new EmployeeCollection();
IDataReader rdr = MyQuery.ExecuteReader();
MyCollection.LoadAndCloseReader(rdr);

return MyCollection;