# NetCore.Sqlite

**Repository Path**: Tigerworm/NetCore.Sqlite

## Basic Information

- **Project Name**: NetCore.Sqlite
- **Description**: How to use The SQLite Local Database in NetCore.
Implement SQLite DB Code-First Create,Add,Query.
and EF to SQL translater logs output.
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2019-03-24
- **Last Updated**: 2022-05-06

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# NetCore.Sqlite

#### Description
How to use The SQLite Local Database in NetCore.
Implement SQLite DB Code-First Create,Add,Query.
and EF to SQL translater logs output.

#### Software Architecture
Coding by .Net Core

#### Installation

1.Before running program,you need add necessary packages.you can find them in "ref nuget libs" folder,
and choose install package in console or visual studio nuget management ui. :smirk:

2.In cmd / Powershell Install command:
`dotnet add [project name] package [package name] -s [source / local path] -v [version]`

- microsoft.entityframeworkcore.sqlite.2.2.3
- microsoft.entityframeworkcore.sqlite.design.1.1.6
- microsoft.entityframeworkcore.tools.2.2.3
- microsoft.extensions.logging.console.2.2.0

#### Instructions

1. Before everything, You must be select whether Need to output information , Because EF will be produce many logs.
2. Detect current folder is exist Sqlite .db file , When program starting.
3. Delete if it exists, create if it does not exist.(base on entity framework core code-first)
4. The Program will insert three tables into database, and will insert little record into each table.
5. The last,use lambda expression to multiple tables join query, and Output query Result.
6. Program will repeat above flow in everytime start.
 
#### Contribution

1. Tigerworm