Add EF6 / SQLite package, Datastore, ConString

[CapCalamity]

PR to close #31

• [x] Add Entity Framework / SQLite
• [x] Implement user history
• [x] Implement DatabaseContext
• [x] Allow Plugins to Save / Retrieve arbitrary Objects
• [x] Allow attachments to existing Objects

---

Things to know:

How to save and load arbitrary objects to DB:

var someContext = new GenericDatabaseContext<SomeClass>();
someContext.Table.Add(new SomeClass());
someContext.SaveChanges();

foreach (var someClass in someContext.Table)
{
    _logger.Warn($"{someClass.Id} - {someClass.CreatedOn}");
}

How to attach a value to an object:

var user = new User("Some_Guy_69");
user.Set("FirstRecorded", DateTime.Now);
// alternatively, use
// Extension.Set(user, "FirstRecorded", DateTime.Now);

• can only attach value to classes that implement IExtendable

[CapCalamity]

any toughts about the current implementation of the Db classes? @SuNflOw1991

[iPaat]

Seems to be okay for me :+1:

[CapCalamity]

With the GenericDatabaseContext, you can now save your objects to a DB. There are some things one needs to know though:

• You need to implement at least a [Key] Attribute for one of your class' properties
  • Data Annotations
• The DB will be saved to %appdata%/local/ibot/gstore.{classHash}.db3

---

With the Extension class you can save a key/value pair to the Database.
Can be used with Extensions.Set / Extension.Get, or use the Extension methods .Set / .Get

[iPaat]

Good work here! :+1: I like it very much! Thanks a lot :)