You organize your data. Now organize your savings.
Set savings goals, track your progress, and stay on course.
This tutorial series shows you how to interact with an SQLite database in C# applications using ADO.NET.
Section 1. Getting Started
In this section, you will learn how to connect to an SQLite database file and create a new table.
- Connecting to an SQLite database – show you how to connect to a SQLite database file using C#.
- Creating a table – learn to create a table in SQLite database file from a C# program.
Section 2. Performing Database Operations
This section covers common database operations including inserting, updating, deleting, and retrieving data. You’ll also learn to import data from a CSV file into a table in an SQLite database.
- Inserting data into a table – Show you how to insert one or more rows into a table in an SQLite database from a C# program.
- Updating data – Learn how to update data in an SQLite table using ADO.NET in C#.
- Deleting data – Discover how to delete data from a table in an SQLite database using a C# program.
- Import CSV file into a table – Show you how to read data from a CSV file and load it into a table in an SQLite database in C#.
- Selecting data – Show you how to retrieve one or more rows from a table in an SQLite database using ADO.NET in C#.
Section 3. Managing Transactions
This section guides you through performing database transactions using C# and ADO.NET.
- Transaction – Learn how to perform a database transaction in SQLite database using C#.
Was this tutorial helpful ?
Yes No