How to create a local sqlite database and publish together to IIS? (Asp.net MVC)

Question

0.00/5 (No votes)

See more:

I am new to SQLite database. What I know currently is SQLite is a small and lightweight standalone database file that we can use without the windows/SQL authentication (correct me if I'm wrong). Most of the SQLite tutorial online is only for ASP.NET Core, how about ASP.NET MVC? My ASP.NET MVC project is currently published to IIS, so I need the SQLite Database can be published along, and also no need to set up SQL Server or any related setup in IIS. Anyway, I have no idea how to start. Appreciate if someone can provide me some tutorial link? Or even the most simplest example. Thanks in advance.

What I have tried:

I have done research on .mdf file which I don't know whether it belongs to the SQLite.

Posted 24-Jun-21 22:10pm

JC YOUNG

Updated 24-Jun-21 23:25pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2021-06-24T23:25:00

There's no difference between using SQLite file and MS Access or MS Excel files.

All you need to do is:
- place SQLite database file in the area (IIS folder) where users can access it,
- download and install an SQLite ODBC driver,
- connect to SQLite database via wizard or add proper connection string manually

See:
c# - How Do I Connect an MVC Razor Pages Project to an MS Access Database - Stack Overflow[^]
c# - ASP.NET MVC application reading data from SQLite database - Stack Overflow[^]
connecting to access database | The ASP.NET Forums[^]
How connect MS Access database to MVC?[^]