// SQLite Functions ------------------------------
/// <summary>
/// Function simply converts a dynamic of a Person object into a strongly typed version.
/// NOTE: Look into building this into the SQLiteEnabled base class using the Activator.CreateInstance().
/// </summary>
/// <param name="dynamicPerson">A person object retrieved from the SQLite database</param>
/// <returns>Strongly typed version of the Person object</returns>
public static Person FromDynamicConverter(dynamic dynamicPerson)
{
Person Returned = new Person();
Returned.ID = dynamicPerson.ID;
Returned.RetreivedValue = dynamicPerson.RetreivedValue;
Returned.FirstName = dynamicPerson.FirstName;
Returned.LastName = dynamicPerson.LastName;
Returned.DateOfBirth = dynamicPerson.DateOfBirth;
Returned.Age = dynamicPerson.Age;
Returned.IsAlive = dynamicPerson.IsAlive;
return Returned;
}
static void Main(string[] args)
{
// Connect or create the SQLite database.
var SQLiteConnection = new SQLiteConnection("Data Source=Sample.db;New=True;Version=3;Max Pool Size=100;");
SQLiteConnection.Open();
// Create the table if it doesn't exist.
if (!SQLiteEnabled.DoesSQLiteTableExist(SQLiteConnection, typeof(Person)))
{
Console.WriteLine(SQLiteEnabled.CreateSQLiteTable(SQLiteConnection, typeof(Person)));
}
// Retrieve any existing people.
// See .ConvertAll<> is what converts from the dynamic to the strongly typed object.
List<Person> People = SQLiteEnabled.RetreiveFromDataBase(SQLiteConnection, typeof(Person)).ConvertAll<Person>(p => Person.FromDynamicConverter(p));
if (People.Count == 0)
{
// If no people exists, then create a bunch of random new people.
for (int i = 0; i < 1000; i++)
{
var NewGuy = new Person();
NewGuy.FirstName = "John";
NewGuy.LastName = "Doe";
NewGuy.DateOfBirth = DateTime.Now.AddYears(0 - i);
NewGuy.Age = i;
NewGuy.IsAlive = true;
People.Add(NewGuy);
}
}
else
{
// Edit every other person so test dirty checking within the commit function.
foreach (var ThisGuy in People.Where(p => p.ID % 2 == 0))
{
ThisGuy.DateOfBirth = ThisGuy.DateOfBirth.AddYears(1);
ThisGuy.Age++;
}
}
// Commit the changes.
// Still a little ugly glue to convert from the strongly typed list to dynamic.
// What I don't like about dynamic in .Net 4.5 is that you can pass a strongly typed object to a function's dynamic parameter,
// but you cannot pass a strongly typed list into a functions list of dynamic parameter.
SQLiteEnabled.CommitData(SQLiteConnection, People.ConvertAll<dynamic>(p => p), typeof(Person));
Console.WriteLine("Derp");
Console.ReadKey();
}
static void Main(string[] args)
{
// Connect or create the SQLite database.
var SQLiteConnection = new SQLiteConnection("Data Source=Sample.db;New=True;Version=3;Max Pool Size=100;");
SQLiteConnection.Open();
// Create the table if it doesn't exist.
if (!SQLiteEnabled.DoesSQLiteTableExist(SQLiteConnection, typeof(Person)))
{
Console.WriteLine(SQLiteEnabled.CreateSQLiteTable(SQLiteConnection, typeof(Person)));
}
// Retrieve any existing people.
// See .ConvertAll<> is what converts from the dynamic to the strongly typed object.
List <Person> People = SQLiteEnabled.RetreiveFromDataBase(SQLiteConnection, typeof(Person)).ConvertAll <Person>(p => Person.FromDynamicConverter(p));
if (People.Count == 0)
{
// If no people exists, then create a bunch of random new people.
for (int i = 0; i < 1000; i++)
{
var NewGuy = new Person();
NewGuy.FirstName = "John";
NewGuy.LastName = "Doe";
NewGuy.DateOfBirth = DateTime.Now.AddYears(0 - i);
NewGuy.Age = i;
NewGuy.IsAlive = true;
People.Add(NewGuy);
}
}
else
{
// Edit every other person so test dirty checking within the commit function.
foreach (var ThisGuy in People.Where(p => p.ID % 2 == 0))
{
ThisGuy.DateOfBirth = ThisGuy.DateOfBirth.AddYears(1);
ThisGuy.Age++;
}
}
// Commit the changes.
// Still a little ugly glue to convert from the strongly typed list to dynamic.
// What I don't like about dynamic in .Net 4.5 is that you can pass a strongly typed object to a function's dynamic parameter,
// but you cannot pass a strongly typed list into a functions list of dynamic parameter.
SQLiteEnabled.CommitData(SQLiteConnection, People.ConvertAll <dynamic>(p => p), typeof(Person));
Console.WriteLine("Derp");
Console.ReadKey();
}
