Here’s a sample code in C# using the .NET framework to write data to a SQLite database
using System; using System.Data.SQLite; namespace SqliteDatabaseWriterExample { class Program { static void Main(string[] args) { // Define the connection string for the SQLite database string connectionString = "Data Source=database.db;Version=3;"; // Define the SQL statement to insert data into the SQLite database string sql = "INSERT INTO Customers (FirstName, LastName, Email) VALUES ('John', 'Doe', 'john.doe@example.com')"; // Create a new instance of the SQLiteConnection class using (SQLiteConnection connection = new SQLiteConnection(connectionString)) { // Open the connection to the SQLite database connection.Open(); // Create a new instance of the SQLiteCommand class using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { // Execute the SQL statement to insert data into the SQLite database int rowsAffected = command.ExecuteNonQuery(); // Print the number of rows affected to the console Console.WriteLine("{0} rows affected.", rowsAffected); } } Console.WriteLine("Data has been written to the SQLite database."); Console.ReadLine(); } } }
In this example, the SQLiteConnection
class is used to create a new instance of the SQLite connection to the SQLite database. The Open
method of the SQLiteConnection
object is used to open the connection. The SQLiteCommand
class is used to create a new instance of the SQL command to insert data into the SQLite database. The ExecuteNonQuery
method of the SQLiteCommand
object is used to execute the SQL statement and insert data into the SQLite database. Finally, the number of rows affected is printed to the console.