Vitsoftol.Snapper 1.0.3 License Info

Vitsoftol.Snapper 1.0.3

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();