#SQL Sharp
This library makes it possible to interact with SQL like most c# objects. It was originally going to only be SQLite but I split it off so that the SQL is separate in case it gets expanded into MYSQL and SQLServer.
It builds off the Microsft SQLite project: https://github.com/aspnet/Microsoft.Data.Sqlite
If you wanted to create a table
SQLCreateTable table = new SQLCreateTable("Customers");
table.AddField("ID", "INTEGER", 0, false, true, true);
table.AddField("Name", "VARCHAR", 30);
table.AddField("Address", "VARCHAR", 30);
table.AddField("City", "VARCHAR", 30);
table.AddField("State", "VARCHAR", 2);
table.AddField("Zip", "VARCHAR", 7);
SQLiteCreate create = new SQLiteCreate(db, table);If you wanted to add multiple rows of data you could do so like this:
SQLInsertTableMultiValues insertvalues = new SQLInsertTableMultiValues("Customers");
insertvalues.SetFields("Name", "Address", "City", "State", "Zip");
insertvalues.AddValues("Bob Moore", "123 No where", "NoneTown", "GH", "14538-3213");
insertvalues.AddValues("Jack Friar", "342 Main St", "Hopetown", "JI", "46753-3234");
SQLiteInsert insert = new SQLiteInsert(db, insertvalues);if you want to do a query
SQLiteSelect select = new SQLiteSelect(db);
select.DoQuery("Customers", "*");To Access the data from the query
SqliteDataReader reader = select.GetReader();
while (reader.Read())
Console.WriteLine($"{reader["ID"]} {reader["Name"]} {reader["Address"]} {reader["City"]} {reader["State"]} {reader["Zip"]}");If you find the library useful, a donation would be appeciated Donate with this link: paypal.me/GColeJr Please choose Friends and Family