Rubrika: Programy

NuGet packages:

System.Data.SQLite

using System.Data.SQLite;
using System;
using System.IO;

namespace SQLite3_CSharp
{
    /// <summary>
    /// This class contains some simple functions 
    /// </summary>
    class Database
    {
        /// <summary>
        /// Return name of file
        /// </summary>
        public string Name { get; private set; }
        private SQLiteConnection connection;

        /// <summary>
        /// Creates new database.
        /// </summary>
        /// <param name="name">Name of database.</param>
        public Database(string name)
        {
            Name = name+".sqlite";
            if (File.Exists(Name))
                throw new Exception("File already exists");
            SQLiteConnection.CreateFile(Name);
            Connect();
        }

        /// <summary>
        /// Connects to existing file.
        /// </summary>
        /// <param name="path">Path to file.</param>
        /// <param name="dummy">Just dummy bool, you can put anything.</param>
        public Database (string path, bool dummy)
        {
            Name = path;
            Connect();
        }

        /// <summary>
        /// Creates connection to database.
        /// </summary>
        private void Connect()
        {
            connection = new SQLiteConnection(string.Format("Data Source = {0}; Version = 3;",Name));
            connection.Open();
        }

        /// <summary>
        /// Just write standard SQL command
        /// </summary>
        /// <param name="input">Command for database.</param>
        public void Command(string input)
        {
            SQLiteCommand sql = new SQLiteCommand(input, connection);
            sql.ExecuteNonQuery();
        }
    }
}