LLBLGen Code Snippets

Deleting multiple rows:

UsersCollection c = new UsersCollection();
SD.LLBLGen.Pro.ORMSupportClasses.IPredicate p;
p = UsersFields.Usernumber == 1234;
c.DeleteMulti(p);

Executing stored procedures:

usersGrid.DataSource = RetrievalProcedures.SelUsers();
usersGrid.DataBind();

Using IDataReader:

TypedListDAO dao = new TypedListDAO();
IDataReader reader = dao.GetAsDataReader(null, RetrievalProcedures.GetSelUsersCallAsQuery(UserID), CommandBehavior.CloseConnection);
while (reader.Read())
{
String s = reader.GetValue(0);
}
reader.Close();

Deleting rows:

UsersEntity e = new UsersEntity(UserID);
e.Delete();

Inserting rows:

UsersEntity e = new UsersEntity();
e.Username = "milonguero";
e.UserNumber = 1234;
e.Save();