مثال:
const string connectionstring = @"...";
using (var db = new DbSql(connectionstring))
{
db.Exec("INSERT User (UserName, Password) VALUES (Admin, 1)");
const string selectFromUser = "SELECT * FROM User";
foreach (var user in db.SelectReader(selectFromUser))
{
}
using (var dataSet = db.FillDataSet(selectFromUser))
{
Console.WriteLine("======");
Console.WriteLine("{0,-20}\t{1}", "UserName", "Password");
foreach (var row in dataSet.Tables[0].Select())
Console.WriteLine("{0,-20}\t{1}", row["UserName"], row["Password"]);
}
db.Exec("DELETE FROM User");
}
البته من ابن کد رو بدون Visual Studio نوشتم. امیدوارم درست باشه