// ====================================================================
// IDE 生成イベントハンドラー
// ====================================================================
private void ButtonCreate_Click(object sender, EventArgs e)
{
try
{
DeleteExistDatabase(DB_NAME_BASIC);
Console.WriteLine("DB を作成します...");
using (SQLiteConnection aConnection = CreateDatabaseConnection(DB_NAME_BASIC))
using (SQLiteCommand aCmd = new SQLiteCommand(aConnection))
{
// ユニーク制約
List <String> aUniques = new List <String>();
aUniques.Add("test_name");
// テーブル作成
LinqUtils.CreateTable(aCmd, typeof(TTestData), aUniques);
// インデックス作成
List <String> aIndices = new List <String>();
aIndices.Add("test_name");
aIndices.Add("test_height");
LinqUtils.CreateIndex(aCmd, LinqUtils.TableName(typeof(TTestData)), aIndices);
// データ挿入
using (DataContext aContext = new DataContext(aConnection))
{
Table <TTestData> aTableTest = aContext.GetTable <TTestData>();
aTableTest.InsertOnSubmit(new TTestData {
Id = 1, Name = "Fukada Kyoko"
});
aTableTest.InsertOnSubmit(new TTestData {
Id = 2, Name = "Eda Ha", Height = 180.0
});
aTableTest.InsertOnSubmit(new TTestData {
Id = 3, Name = "Dan Gerou", Height = 150.5
});
aTableTest.InsertOnSubmit(new TTestData {
Id = 4, Name = "Baba Takashi"
});
aTableTest.InsertOnSubmit(new TTestData {
Id = 5, Name = "Aikawa Ai", Height = 145.6
});
aContext.SubmitChanges();
Console.WriteLine("DB にテーブルを作成しました。件数：" + aTableTest.Count().ToString());
}
}
}
catch (Exception oExcep)
{
Console.WriteLine(oExcep.Message);
}
}