Breaking News: Grepper is joining You.com. Read the official announcement!

create a sqlite database c#

Old-fashioned Osprey answered on March 9, 2022 Popularity 9/10 Helpfulness 5/10

answer create a sqlite database c#

related Create SQLite Db and table using C#

create a sqlite database c#

Comment

SQLiteConnection.CreateFile("MyDatabase.sqlite");

SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
m_dbConnection.Open();

string sql = "create table highscores (name varchar(20), score int)";

SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();

sql = "insert into highscores (name, score) values ('Me', 9001)";

command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();

m_dbConnection.Close();

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: c# database sql sqlite

Link to this answer
Share Copy Link

Contributed on Mar 09 2022

Old-fashioned Osprey

0 Answers Avg Quality 2/10

Closely Related Answers

Create SQLite Db and table using C#

Comment

/// 09/09/2022 Mahesh Kumar Yadav. <br/>
/// <summary>
/// Create Db and Table 
/// </summary>
/// <param name="path"></param>
private void CreateSqLiteDb(string path)
{
    SQLiteConnection.CreateFile(path);

    _connectionString = "Data Source=" + path;
    var mDbConnection = new SQLiteConnection(_connectionString);
    using (mDbConnection)
    {
        mDbConnection.Open();
        const string createTableStatement =
            "CREATE TABLE `Entities` ( `SN` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `ID` TEXT NOT NULL, `Name` TEXT NOT NULL, `OwnerID` TEXT, `IsGroup` INTEGER, `Status` TEXT, `Properties` TEXT, `Email` TEXT, `FirstName` TEXT, `LastName` TEXT, `AssociatedUsersOrGroups` TEXT, `GroupID` TEXT);";
        var command = new SQLiteCommand(createTableStatement, mDbConnection);
        command.ExecuteNonQuery();
        mDbConnection.Close();
    }
}

Popularity 8/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c# sqlite using usin

Link to this answer
Share Copy Link

Contributed on Sep 09 2022

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

create a sqlite database c#

Contents

More Related Answers

create a sqlite database c#

Closely Related Answers

Create SQLite Db and table using C#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.