dBParser

The No Hassle Database Handler

Check the demo and docs: http://dbParser.com/

I wanted an all in one package to handle different SQL based database engines.

Based on CRUD persistent storage.

---

Supports:

• sql
• sqlite
• oracle
• mysql

Basic Usage

Head over to the docs for more information.

//Init 
ConfigHelper config = new ConfigHelper("Data Source=.\\SQLEXPRESS;Initial Catalog=DB_HERE;User ID=USERID_HERE;Password=USER_PWD;", "sql");

//Config is held in cache for up to a year... To clear. Just run
DbUtils.DeleteCache("dbParserConfig");

//Construct new databaseparser...
IDBParser dB = DbUtils.GetDBType();

DataTable dt = dB.Read("select * from accountusers");

//Caching via 
DataTable dt DbUtils.ReadCache("select * from accountusers");

//Full Database Extended Properties
string value = DbUtils.ReadExtendedPropCache("database_settings", true);

//Can use this to write any query to db
dB.Read("");

//Ability to Output Majority of values
db.AddParameter("userid", 5);
db.EndParameter("username", "DbParser");
...
dB.AddNewReturnGuid("accountusers", "Inserted.UserTokenGuid");

//InsertUpdate will Update if the where condition is met, else it will insert. Can also output values.
dB.InsertUpdate("accountusers", "UserId = 5", "Inserted.UserId");