// dotnet add package Microsoft.EntityFrameworkCore.Sqlite

​

// 4 different methods that return the method as an object

// get object by ID

// delete item by ID

// update item by ID

// save NEW item

// list all items

// give these methods their own class, "ItemDAO"

​

using System;

using System.Collections.Generic;

using Microsoft.Data.Sqlite;

​

namespace _09week_1

{

    class Program

    {

        static void Main(string[] args)

        {

            // Make connection string

            SqliteConnectionStringBuilder connectionStringBuilder = new SqliteConnectionStringBuilder();

            connectionStringBuilder.DataSource = "./database.db";

​

            // Make connection

            SqliteConnection connection = new SqliteConnection(connectionStringBuilder.ConnectionString);

            connection.Open();

​

            // Make command

            SqliteCommand command = connection.CreateCommand();

            command.CommandText = "SELECT * FROM toys;";

            SqliteDataReader reader = null;

​

            try

            {

            }

            catch (Microsoft.Data.Sqlite.SqliteException e)

            {

                if (e.Message.Contains("no such table: toys"))

                {

                    Console.WriteLine("No table called toys exists. Now making one.");

​

                    SqliteCommand createTableCommand = connection.CreateCommand();

                    createTableCommand.CommandText = "CREATE TABLE toys (id integer, name text);";

                    createTableCommand.ExecuteNonQuery();

​

                    reader = command.ExecuteReader();

                }

            }

​

            reader = null;

            reader = command.ExecuteReader();

​

            // int numOfColumns = reader.FieldCount;

            // Console.WriteLine("The number of columns returned is : " + numOfColumns);

​

            // for (int c = 0; c < numOfColumns; c++)

            // {

            //     Console.WriteLine("the column at position {0} is called {1}", c, reader.GetName(c));

            // }

​

            SqliteCommand insertCommand = new SqliteCommand();

​

            insertCommand = connection.CreateCommand();

            insertCommand.CommandText = "DELETE FROM toys WHERE id = 2;";

            int code = insertCommand.ExecuteNonQuery();

​

            while (reader.Read())

            {

                int id = reader.GetInt32(0);

                string name = reader.GetString(1);

                Console.WriteLine("{0} | {1}", id, name);

            }

​

            // int count = 0;

            // while(reader.Read())

            // {

​

            //     Console.WriteLine("I am reading a result from the query. Count: {0}", ++count);

            // }

        }

    }

​

    class Toy

    {

        public int id { get; set; }

        public string name { get; set; }

    }

}

​