Skip to content

xanthium-enterprises/Basic-Sqlite-Database-CRUD-Operations-using-Csharp-on-Dotnet-Platform

Repository files navigation

Basic Sqlite Database CRUD Operations using C# on .NET Platform for Novices

Tutorial

Introduction

  • In this repo you will find C# source codes for performing CRUD operations on a SQLite3 Database using C# (CSharp) along with a sample Sqlite database to practise.

  • We have an online tutorial as well as a Youtube Video for beginners (link above) who are new to C# and SQlite 3 Database that will teach the user

    • How to setup Visual Studio to communicate with Sqlite 3 Database
    • How to setup .NET CLI Project to communicate with Sqlite 3 Database
    • How to create a table inside the SQlite3 database using C#
    • How to insert data into the table inside Sqlite database using C#
    • How to read data from a sqlite database record using C#
    • How to handle null values while reading data from a sqlite database using C#
    • How to update a record in the sqlite database using C#
    • How to delete a record in the sqlite database using C#

Repo Contents

  • C# Source Codes
  • Visual Studio Project files
  • Sample Sqlite Database

Some Screenshots

  • Reading rows from sqlite database using C# -Reading rows from sqlite database using C#

  • Updating Rows of Sqlite DB from Command line using C#

  • Updating Rows of Sqlite DB from Command line using C#

Additional Links