Package free for use.
This package allows database conections with Oracle, MySQL, MSQLSrver and FireBird that allow you do execute DML commands as Select, Update and Delete.
Example o use:
//Select Example
var con = new Command(new SnapperConnectionData
{
DataBase = "Kernel",
Password = "Pirilampo$9045",
Server = "localhost",
Uid = "root"
});
con.CreateSnapper("select * from Cliente", null);
//DataTable data container. Object that will populate
var tb = new DataTable();
con.Execute(tb);
NOTE: If your database is MySQL you doesn1t need declare Engine
//Update Example
var con = new Command(new SnapperConnectionData
{
DataBase = "Kernel",
Password = "Pirilampo$9045",
Engine = new MySQLEngine(), //For Oracle use "OracleEngine", SQLServer "MSQLServerEngine", Firebird "InterBaseEngine"
Server = "localhost",
Uid = "root"
});
--> parameter must have (p) before name. Doesn't matters Engine
con.CreateSnapper("update table set x = (p)x, a = (p)a, b = (p)b",
new List<Parameter>
{
new Parameter {Name = "x", Value = 1},
new Parameter {Name = "a", Value = 2},
new Parameter {Name = "b", Value = "zas"}
}
);
con.Execute();