A very simple way to work with the database
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var select = SQLite.select(connectionString, "select id, name, lastname, age from users");
var items = select.result;
foreach(var item in items)
{
Console.WriteLine("id:" + item["id"] + ", name:" + item["name"] + ", lastname:" + item["lastname"] + ", age:" + item["age"]);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var select = SQLite.select(connectionString, "select id, name, lastname, age from users where id = @user_id", new Dictionary<string, object>{{"@user_id", 1}});
var items = select.result
foreach(var item in items)
{
Console.WriteLine("id:" + item["id"] + ", name:" + item["name"] + ", lastname:" + item["lastname"] + ", age:" + item["age"]);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var select = SQLite.select(connectionString, "select id, name, lastname, age from users");
if(select.execute)
{
foreach(var item in select.result)
{
Console.WriteLine("id:" + item["id"] + ", name:" + item["name"] + ", lastname:" + item["lastname"] + ", age:" + item["age"]);
}
}
else
{
Console.WriteLine("No result!" + select.message);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var query = SQLite.query(connectionString, "insert into users(name, lastname, age) values('Gholibjon', 'Madiyarov', 29)");
if(query.execute)
{
Console.WriteLine("Request completed successfully " + query.message);
}
else
{
Console.WriteLine("Request failed " + query.message);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var query = SQLite.query(connectionString, "insert into users(name, lastname, age) values(@name, @lastname, @age)", new Dictionary<string, object>{{"@name", "Gholibjon"}, {"@lastname", "Madiyarov"}, {"@age", 29}});
if(query.execute)
{
Console.WriteLine("Request completed successfully " + query.message);
}
else
{
Console.WriteLine("Request failed " + query.message);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var queries = new List<string>(){
"insert into users(name, lastname, age) values('Gholibjon', 'Madiyarov', 29)",
"insert into cities(name, description) values('Hujand', 'This is one of the most civilized and hospitable cities in Central Asia.')",
"insert into cars(name, description) values('Mercedes Benz', 'One of the most perfect and friendly cars in the world.')"
};
var query = SQLite.query(connectionString, queries);
if(query.execute)
{
Console.WriteLine("Request completed successfully " + query.message);
}
else
{
Console.WriteLine("Request failed " + query.message);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var queries = new List<string>(){
"insert into users(name, lastname, age) values(@name, @lastname, @age)",
"insert into cities(name, description) values(@name, @description)",
"insert into cars(name, description) values(@name, @description)"
};
var parameters = new List<Dictionary<string, object>>{
new Dictionary<string, object>{{"@name", "Gholibjon"}, {"@lastname", "Madiyaov"}, {"@age", 29}},
new Dictionary<string, object>{{"@name", "Hujand"}, {"@description", "This is one of the most civilized and hospitable cities in Central Asia."}},
new Dictionary<string, object>{{"@name", "Mercedes Benz"}, {"@description", "One of the most perfect and friendly cars in the world."}},
};
var query = SQLite.query(connectionString, queries, parameters);
if(query.execute)
{
Console.WriteLine("Request completed successfully " + query.message);
}
else
{
Console.WriteLine("Request failed " + query.message);
}
}
using Bee.SQLite;
static void Main(string[] args)
{
var connectionString = "data source=Company.db;version=3;page size=4096;cache size=10000;journal mode=Wal;pooling=True;legacy format=False;default timeout=15000";
var queries = new List<string>(){
"insert into users(name, lastname, age) values(@name, @lastname, @age)",
"insert into cities(name, description) values('Hujand', 'This is one of the most civilized and hospitable cities in Central Asia.')",
"insert into cars(name, description) values(@name, @description)"
};
var parameters = new List<Dictionary<string, object>>{
new Dictionary<string, object>{{"@name", "Gholibjon"}, {"@lastname", "Madiyaov"}, {"@age", 29}},
null,
new Dictionary<string, object>{{"@name", "Mercedes Benz"}, {"@description", "One of the most perfect and friendly cars in the world."}},
};
var query = SQLite.query(connectionString, queries, parameters);
if(query.execute)
{
Console.WriteLine("Request completed successfully " + query.message);
}
else
{
Console.WriteLine("Request failed " + query.message);
}
}