public Save()
{
DatabaseCursor db = new DatabaseCursor();
db.Connect(@"C:\Users\Ali Efe GÜR\Desktop\saveTestAsync.alfdb");
DateTime start = DateTime.Now;
DateTime start1 = DateTime.Now;
db.CreateTable("students",
true,
new string[] { "id", "name", "last_name", "class", "mark" });
db.GoToTable("students");
for (int i = 0; i < 10; i++)
{
for (int j = 0; j < 10000; j++)
{
db.AddRecord(new string[] {
"name", "last_name", "class", "mark"
}, new string[] {
"Ali Efe", "GÜR", "11/B", "97.38"
});
}
DateTime finishTime1 = DateTime.Now;
Console.WriteLine(((i + 1) * 10000).ToString() + " tane kayıt keydedildi!");
Console.WriteLine((finishTime1 - start1).TotalMilliseconds.ToString() + " milisaniyede\n");
start1 = DateTime.Now;
}
Console.WriteLine("Tüm kayıtlar", (DateTime.Now - start).ToString() + " sürede işlendi!");
db.CommitAsync();
Console.WriteLine(DateTime.Now - start);
}
public SaveData()
{
// Veritabanı imleci oluşturup bir veritabanına bağlanır
DatabaseCursor database = new DatabaseCursor();
database.Connect(@"C:\Users\Ali Efe GÜR\Desktop\myDatabase.alfdb");
database.CreateTableIfNotExists("personalData", true, new string[]
{
"id",
"name",
"last_name"
});
database.CreateTableIfNotExists("students", false, new string[]
{
"no",
"class",
"school",
"markAverage"
});
database.CreateTableIfNotExists("teachers", false, new string[]
{
"name",
"last_name",
"branch"
});
database.CreateTableIfNotExists("workers", false, new string[]
{
"name",
"last_name",
"department",
"salary"
});
database.CreateTableIfNotExists("products", false, new string[]
{
"model",
"brand",
"price",
"rate"
});
database.CreateTableIfNotExists("films", false, new string[]
{
"name",
"director",
"imdb"
});
database.CreateTableIfNotExists("games", false, new string[]
{
"name",
"platform",
"type"
});
database.CreateTableIfNotExists("programmingLanguages", false, new string[]
{
"name",
"compilable",
"platform"
});
database.GoToTable("personalData");
database.AddRecord(new string[] { "name", "last_name" },
new string[] { "Ali Efe", "GÜR" });
database.AddRecord(new string[] { "name", "last_name" },
new string[] { "Mehmet", "YILMAZ" });
database.AddRecord(new string[] { "name", "last_name" },
new string[] { "Hale", "KAYA" });
database.AddRecord(new string[] { "name", "last_name" },
new string[] { "Orhun Ege", "GÜR" });
Console.WriteLine("Database saving...");
database.Commit();
Console.WriteLine("Database saved!");
}