private System.Data.IDbCommand GetCommand(PropertyInfo prop)
{
AssertCsvFile(prop);
var sql = string.Format("SELECT * FROM [{0}.csv]", prop.Name);
var result = TheDataConnection.CreateCommand();
result.CommandText = sql;
return(result);
}
private void InitializeConnection()
{
TheDataConnection.Disposed += delegate
{
Directory.GetFiles(DataFolder).ToList().ForEach(File.Delete);
Directory.Delete(DataFolder);
};
if (!Directory.Exists(DataFolder))
{
Directory.CreateDirectory(DataFolder);
}
Disposed += delegate { TheDataConnection.Dispose(); };
TheDataConnection.ConnectionString = CsvConnectionString;
TheDataConnection.Open();
}