1. Add()
Insert a record.
DAL
tbl.Value["event"] = "First event";
tbl.Add();Database API
var data = new Dictionary<string, object>()
{
{"event", "First event"}
};
DB.Insert("EventsTable", data);2. Update()
Update existing records.
DAL
tbl.Param["ID"] = 10;
tbl.Value["event"] = "Updated event";
tbl.Update();Database API
var data = new Dictionary<string, object>()
{
{"event", "Updated event"}
};
var where = new Dictionary<string, object>()
{
{"ID", 10}
};
DB.Update("EventsTable", data, where);3. Delete()
Delete records.
DAL
tbl.Param["ID"] = 10;
tbl.Delete();Database API
var where = new Dictionary<string, object>()
{
{"ID", 10}
};
DB.Delete("EventsTable", where);4. Query()
Select records with sorting.
DAL
var rs = tbl.Query("ID=10", "Name");
Database API
var rs = DB.Query("SELECT * FROM EventsTable WHERE ID=10 ORDER BY Name");
5. QueryAll()
Select all records.
DAL
var rs = tbl.QueryAll();
Database API
var rs = DB.Query("SELECT * FROM EventsTable");
6. FetchByID()
Retrieve records matching parameters.
DAL
tbl.Param["ID"] = 10;
var rs = tbl.FetchByID();Database API
var rs = DB.Select(
"EventsTable",
new Dictionary<string, object>()
{
{"ID", 10}
}
);7. CustomQuery()
Execute arbitrary SQL.
DAL
var rs = CustomQuery("SELECT * FROM users");
Database API
var rs = DB.Query("SELECT * FROM users");
8. DBLookup()
Return the first value of the first row.
DAL
var value = DBLookup("SELECT zip FROM users WHERE userid=25");
Database API
var value = DB.Query(
"SELECT zip FROM users WHERE userid=25"
).Value();9. TableName()
Return the table name.
DAL
string sql = "SELECT * FROM " + tbl.TableName();
Database API
You just need to hardcode the table name.
string sql = "SELECT * FROM EventsTable";
10. UsersTableName()
Return the login table name.
DAL
string sql = "SELECT * FROM " + UsersTableName();
Database API
string table = Security.GetUserTable();
