internal Table GetTableByName(string dbName, string tableName)
{
if (String.IsNullOrEmpty(dbName))
{
throw new ArgumentNullException(nameof(dbName));
}
if (String.IsNullOrEmpty(tableName))
{
throw new ArgumentNullException(nameof(tableName));
}
DatabaseClient db = GetDatabaseClient(dbName);
if (db == null)
{
_Logging.Warn("GetTableByName unable to find client for database " + dbName);
return(null);
}
Table ret = new Table();
ret.Name = tableName;
ret.Columns = new List <Column>();
List <DatabaseWrapper.Core.Column> columns = db.DescribeTable(tableName);
if (columns == null || columns.Count < 1)
{
_Logging.Warn("GetTableByName no columns found for table " + tableName + " in database " + dbName);
return(null);
}
foreach (Column currColumn in columns)
{
Column tempColumn = new Column();
tempColumn.Name = currColumn.Name;
tempColumn.Nullable = currColumn.Nullable;
tempColumn.MaxLength = currColumn.MaxLength;
tempColumn.Type = currColumn.Type;
if (currColumn.PrimaryKey)
{
tempColumn.PrimaryKey = true;
ret.PrimaryKey = tempColumn.Name;
}
ret.Columns.Add(tempColumn);
}
return(ret);
}
/// <summary>
/// Create table (if it doesn't exist) for a given class.
/// Adding a table that has already been added will throw an ArgumentException.
/// </summary>
/// <param name="t">Class for which a table should be created.</param>
public void InitializeTable(Type t)
{
if (!_Initialized)
{
throw new InvalidOperationException("Initialize WatsonORM and database using the .InitializeDatabase() method first.");
}
if (t == null)
{
throw new ArgumentNullException(nameof(t));
}
string tableName = ReflectionHelper.GetTableNameFromType(t);
string primaryKeyPropertyName = ReflectionHelper.GetPrimaryKeyPropertyName(t);
List <Column> columns = ReflectionHelper.GetColumnsFromType(t);
if (String.IsNullOrEmpty(tableName))
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have a 'Table' attribute.");
}
if (String.IsNullOrEmpty(primaryKeyPropertyName))
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have a property with the 'PrimaryKey' attribute.");
}
if (columns == null || columns.Count < 1)
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have any properties with a 'Column' attribute.");
}
if (!_Database.TableExists(tableName))
{
_Database.CreateTable(tableName, columns);
}
else
{
List <Column> existingColumns = _Database.DescribeTable(tableName);
foreach (Column column in columns)
{
if (!existingColumns.Exists(c => c.Name.Equals(column.Name)))
{
throw new InvalidOperationException("Table '" + tableName + "' exists but column '" + column.Name + "' does not.");
}
}
List <string> existingColumnNames = existingColumns.Select(c => c.Name).ToList();
List <string> definedColumnNames = columns.Select(c => c.Name).ToList();
List <string> delta = existingColumnNames.Except(definedColumnNames).ToList();
if (delta != null && delta.Count > 0)
{
string deltaStr = "";
foreach (string currDelta in delta)
{
if (!String.IsNullOrEmpty(deltaStr))
{
deltaStr = deltaStr + ", ";
}
deltaStr += currDelta;
}
_Logger?.Invoke(_Header + "table " + tableName + " contains additional columns not decorated in the class definition: " + deltaStr);
}
}
_TypeMetadataMgr.Add(t, new TypeMetadata(tableName, primaryKeyPropertyName, columns));
_Logger?.Invoke(_Header + "initialized table " + tableName + " for type " + t.Name + " with " + columns.Count + " column(s)");
}
static void Main(string[] args)
{
Console.WriteLine("Opening file");
DatabaseClient sql = new DatabaseClient("test");
sql.Logger = Logger;
sql.LogQueries = true;
sql.LogResults = true;
Console.WriteLine("Creating table...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Integer, false));
columns.Add(new Column("name", false, DataType.Text, true));
columns.Add(new Column("postal", false, DataType.Integer, true));
sql.CreateTable("company", columns);
Console.WriteLine("Checking if table 'company' exists: " + sql.TableExists("company"));
Console.WriteLine("Retrieving list of tables...");
List <string> tableNames = sql.ListTables();
if (tableNames != null && tableNames.Count > 0)
{
foreach (string curr in tableNames)
{
Console.WriteLine(" " + curr);
}
}
Console.WriteLine("Describing database...");
Dictionary <string, List <Column> > describeResult = sql.DescribeDatabase();
if (describeResult != null && describeResult.Count > 0)
{
foreach (KeyValuePair <string, List <Column> > curr in describeResult)
{
Console.WriteLine(" Table " + curr.Key);
if (curr.Value != null && curr.Value.Count > 0)
{
foreach (Column col in curr.Value)
{
Console.WriteLine(" " + col.ToString());
}
}
}
}
Console.WriteLine("Describing table 'company'...");
List <Column> cols = sql.DescribeTable("company");
if (cols != null && cols.Count > 0)
{
foreach (Column curr in cols)
{
Console.WriteLine(" " + curr.ToString());
}
}
Console.WriteLine("Adding data...");
Dictionary <string, object> d1 = new Dictionary <string, object>();
d1.Add("name", "company 1");
d1.Add("postal", 95128);
Dictionary <string, object> d2 = new Dictionary <string, object>();
d2.Add("name", "company 2");
d2.Add("postal", 62629);
Dictionary <string, object> d3 = new Dictionary <string, object>();
d3.Add("name", "company 3");
d3.Add("postal", 10101);
Dictionary <string, object> d4 = new Dictionary <string, object>();
d4.Add("name", "company 4");
d4.Add("postal", 90210);
Console.WriteLine("Created ID: " + sql.Insert("company", d1).ToString());
Console.WriteLine("Created ID: " + sql.Insert("company", d2).ToString());
Console.WriteLine("Created ID: " + sql.Insert("company", d3).ToString());
Console.WriteLine("Created ID: " + sql.Insert("company", d4).ToString());
Console.WriteLine("Selecting companies with postal > 70000...");
Expression eRetrieve1 = new Expression("postal", Operators.GreaterThan, 70000);
DataTable selectResult1 = sql.Select("company", 0, null, null, eRetrieve1, null);
Console.WriteLine("Retrieved " + selectResult1.Rows.Count + " rows");
Console.WriteLine("Selecting companies with postal > 70000 or postal < 50000...");
Expression eRetrieve2 = new Expression
{
LeftTerm = new Expression("postal", Operators.GreaterThan, 70000),
Operator = Operators.Or,
RightTerm = new Expression("postal", Operators.LessThan, 50000)
};
DataTable selectResult2 = sql.Select("company", 0, null, null, eRetrieve2, null);
Console.WriteLine("Retrieved " + selectResult2.Rows.Count + " rows");
Console.WriteLine("Deleting records...");
Expression eDelete = new Expression("id", Operators.GreaterThan, 0);
sql.Delete("company", eDelete);
Console.WriteLine("Dropping table...");
sql.DropTable("company");
}
static void Main(string[] args)
{
try
{
#region Select-Database-Type
/*
*
*
* Create the database 'test' before proceeding if using mssql, mysql, or pgsql
*
*
*/
Console.Write("User: "******"Password: "******"localhost", 1433, user, pass, null, "test");
_Database = new DatabaseClient(_Settings);
_Database.Logger = Logger;
_Database.LogQueries = true;
_Database.LogResults = true;
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table '" + _Table + "'...");
_Database.DropTable(_Table);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Creating table '" + _Table + "'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstname", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastname", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
_Database.CreateTable(_Table, columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Table '" + _Table + "' exists: " + _Database.TableExists(_Table));
Console.WriteLine("Table '" + _Table + "' configuration:");
columns = _Database.DescribeTable(_Table);
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading multiple rows...");
LoadMultipleRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Checking existence...");
ExistsRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Counting age...");
CountAge();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Summing age...");
SumAge();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by between...");
RetrieveRowsByBetween();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving sorted rows...");
RetrieveRowsSorted();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Cause-Exception
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Testing exception...");
try
{
_Database.Query("SELECT * FROM " + _Table + "(((");
}
catch (Exception e)
{
Console.WriteLine("Caught exception: " + e.Message);
Console.WriteLine("Query: " + e.Data["Query"]);
}
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table...");
_Database.DropTable(_Table);
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
internal List <Table> GetTables(string dbName, bool describe)
{
if (String.IsNullOrEmpty(dbName))
{
throw new ArgumentNullException(nameof(dbName));
}
DatabaseClient db = GetDatabaseClient(dbName);
if (db == null)
{
_Logging.Warn("GetTables unable to find client for database " + dbName);
return(null);
}
List <string> tableNames = db.ListTables();
if (tableNames == null || tableNames.Count < 1)
{
_Logging.Warn("GetTables no tables returned from list tables for database " + dbName);
return(new List <Table>());
}
else
{
_Logging.Debug("GetTables returning " + tableNames.Count + " tables for database " + dbName);
}
List <Table> ret = new List <Table>();
foreach (string curr in tableNames)
{
Table currTable = new Table();
currTable.Name = curr;
if (describe)
{
currTable.Columns = new List <Column>();
List <DatabaseWrapper.Core.Column> columns = db.DescribeTable(curr);
if (columns == null || columns.Count < 1)
{
_Logging.Warn("GetTables no columns found for table " + curr + " in database " + dbName);
ret.Add(currTable);
continue;
}
foreach (DatabaseWrapper.Core.Column currColumn in columns)
{
Column tempColumn = new Column();
tempColumn.Name = currColumn.Name;
tempColumn.Nullable = currColumn.Nullable;
tempColumn.MaxLength = currColumn.MaxLength;
tempColumn.Type = currColumn.Type;
if (currColumn.PrimaryKey)
{
currTable.PrimaryKey = tempColumn.Name;
}
currTable.Columns.Add(tempColumn);
// _Logging.Debug("GetTables adding column " + tempColumn.Name + " for table " + currTable.Name + " database " + dbName);
}
}
ret.Add(currTable);
}
return(ret);
}
/// <summary>
/// Validate a table to determine if any errors or warnings exist.
/// </summary>
/// <param name="t">Class for which a table should be validated.</param>
/// <param name="errors">List of human-readable errors.</param>
/// <param name="warnings">List of human-readable warnings.</param>
/// <returns>True if the table will initialize successfully.</returns>
public bool ValidateTable(Type t, out List <string> errors, out List <string> warnings)
{
if (!_Initialized)
{
throw new InvalidOperationException("Initialize WatsonORM and database using the .InitializeDatabase() method first.");
}
if (t == null)
{
throw new ArgumentNullException(nameof(t));
}
errors = new List <string>();
warnings = new List <string>();
string tableName = ReflectionHelper.GetTableNameFromType(t);
string primaryKeyPropertyName = ReflectionHelper.GetPrimaryKeyPropertyName(t);
List <Column> columns = ReflectionHelper.GetColumnsFromType(t);
bool success = true;
if (String.IsNullOrEmpty(tableName))
{
errors.Add("Type '" + t.Name + "' does not have a 'Table' attribute.");
success = false;
}
if (String.IsNullOrEmpty(primaryKeyPropertyName))
{
errors.Add("Type '" + t.Name + "' with table name '" + tableName + "' does not have a property with the 'PrimaryKey' attribute.");
success = false;
}
if (columns == null || columns.Count < 1)
{
errors.Add("Type '" + t.Name + "' with table name '" + tableName + "' does not have any properties with a 'Column' attribute.");
success = false;
}
if (!_Database.TableExists(tableName))
{
warnings.Add("Type '" + t.Name + "' with table name '" + tableName + "' has not yet been created and will be created upon initialization.");
}
else
{
List <Column> existingColumns = _Database.DescribeTable(tableName);
foreach (Column column in columns)
{
if (!existingColumns.Exists(c => c.Name.Equals(column.Name)))
{
errors.Add("Type '" + t.Name + "' with table name '" + tableName + "' exists but column '" + column.Name + "' does not.");
success = false;
}
}
List <string> existingColumnNames = existingColumns.Select(c => c.Name).ToList();
List <string> definedColumnNames = columns.Select(c => c.Name).ToList();
List <string> delta = existingColumnNames.Except(definedColumnNames).ToList();
if (delta != null && delta.Count > 0)
{
foreach (string curr in delta)
{
warnings.Add("Type '" + t.Name + "' with table name '" + tableName + "' contains additional column '" + curr + "' which is not annotated in the type.");
}
}
}
return(success);
}
static void Main(string[] args)
{
try
{
#region Setup-Database
Console.Write("Filename: ");
string filename = Console.ReadLine();
if (String.IsNullOrEmpty(filename))
{
return;
}
_Settings = new DatabaseSettings(filename);
_Database = new DatabaseClient(_Settings);
_Database.Logger = Logger;
_Database.LogQueries = true;
_Database.LogResults = true;
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table 'person'...");
_Database.DropTable("person");
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Creating table 'person'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
_Database.CreateTable("person", columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Table 'person' exists: " + _Database.TableExists("person"));
Console.WriteLine("Table 'person' configuration:");
columns = _Database.DescribeTable("person");
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by between...");
RetrieveRowsByBetween();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table...");
_Database.DropTable("person");
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
static void Main(string[] args)
{
try
{
#region Select-Database-Type
/*
*
*
* Create the database 'test' before proceeding
*
*
*/
Console.Write("DB type [mssql|mysql|pgsql]: ");
string dbType = Console.ReadLine();
if (String.IsNullOrEmpty(dbType))
{
return;
}
Console.Write("User: "******"Password: "******"mssql":
client = new DatabaseClient(DbTypes.MsSql, "localhost", 1433, user, password, null, "test");
break;
case "mysql":
client = new DatabaseClient(DbTypes.MySql, "localhost", 3306, user, password, null, "test");
break;
case "pgsql":
client = new DatabaseClient(DbTypes.PgSql, "localhost", 5432, user, password, null, "test");
break;
default:
return;
}
client.DebugRawQuery = true;
client.DebugResultRowCount = true;
#endregion
#region Drop-Table
Console.WriteLine("Dropping table 'person'...");
client.DropTable("person");
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
Console.WriteLine("Creating table 'person'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
client.CreateTable("person", columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
Console.WriteLine("Table 'person' exists: " + client.TableExists("person"));
Console.WriteLine("Table 'person' configuration:");
columns = client.DescribeTable("person");
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Drop-Table
Console.WriteLine("Dropping table...");
client.DropTable("person");
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
static void Main(string[] args)
{
try
{
#region Select-Database-Type
/*
*
*
* Create the database 'test' before proceeding if using mssql, mysql, or pgsql
*
*
*/
Console.Write("DB type [sqlserver|mysql|postgresql|sqlite]: ");
string dbType = Console.ReadLine();
if (String.IsNullOrEmpty(dbType))
{
return;
}
dbType = dbType.ToLower();
if (dbType.Equals("sqlserver") || dbType.Equals("mysql") || dbType.Equals("postgresql"))
{
Console.Write("User: "******"Password: "******"sqlserver":
_Settings = new DatabaseSettings("localhost", 1433, user, pass, null, "test");
_Database = new DatabaseClient(_Settings);
break;
case "mysql":
_Settings = new DatabaseSettings(DbTypes.Mysql, "localhost", 3306, user, pass, "test");
_Database = new DatabaseClient(_Settings);
break;
case "postgresql":
_Settings = new DatabaseSettings(DbTypes.Postgresql, "localhost", 5432, user, pass, "test");
_Database = new DatabaseClient(_Settings);
break;
default:
return;
}
}
else if (dbType.Equals("sqlite"))
{
Console.Write("Filename: ");
string filename = Console.ReadLine();
if (String.IsNullOrEmpty(filename))
{
return;
}
_Settings = new DatabaseSettings(filename);
_Database = new DatabaseClient(_Settings);
}
else
{
Console.WriteLine("Invalid database type.");
return;
}
_Database.Logger = Logger;
_Database.LogQueries = true;
_Database.LogResults = true;
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table 'person'...");
_Database.DropTable("person");
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Creating table 'person'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
_Database.CreateTable("person", columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Table 'person' exists: " + _Database.TableExists("person"));
Console.WriteLine("Table 'person' configuration:");
columns = _Database.DescribeTable("person");
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by between...");
RetrieveRowsByBetween();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table...");
_Database.DropTable("person");
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
