A C# code snippet to determine if a database file exists, if it doesn't create it and add data to it.

SeedData.cs

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

package Gist
{
  public class SeedData
  {
    string readonly dbPath = "database.db";
    string readonly dbConnectionString = "Data Source=" + dbPath;

    public bool VerifyData()
    {
      if(!File.Exists(dbPath))
      {
        SQLiteConnection.CreateFile(dbPath);
        return PopulateDatabase();
      }
      else
      {
        return true;
      }
    }

    private bool PopulateDatabase()
    {
      try
      {
        SQLiteConnection connection = new SQLiteConnection(dbConnectionString);
        connection.Open();
        //
        // Modify this table creation script to fit your needs
        SQLiteCommand command = new SQLiteCommand("CREATE TABLE IF NOT EXISTS [Users] (Firstname VARCHAR, Surname VARCHAR, Username VARCHAR CONSTRAINT pk PRIMARY KEY, Password VARCHAR)", connection);
        command.ExecuteNonQuery();

        // Insert your data in this way. 
        command = new SQLiteCommand("INSERT INTO [Users] VALUES ()", connection);
        command.ExecuteNonQuery();
        
        connection.Close();

        return true;
      }
      catch (Exception)
      {
        return false;
      }
    }
  }
}