.NET
Microsoft Technologies based on the .NET software framework.
3,363 questions
the connection string is simply: "Data Source=c:\Data\SeguroMedicoMFC.sqlite;"
I want to connect from EntityFrameworkCore to sqlite3 database but don't know how to obtain connection string...
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 4%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Juan Dent
236
Reputation points
I have created a console project for C# and installed the following packages:
Microsoft.EntityFrameworkCore.Sqlite
Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Tools
I have a sqlite3 database at a path c:\Data\db.sqlite
How can I connect to this database (in particular what is the connection string?) and how can I reverse engineer the database into my C# project? (i.e. creation of DbContext and models)
.NET
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,682 questions
{count} votes
-
Juan Dent 236 Reputation points
2022-08-24T18:26:02.29+00:00 I tried this in Package Manager Console:
scaffold-DbContext "Data Source=c:\Data\SeguroMedicoMFC.sqlite;"and I got this question:
Supply values for the following parameters:
Provider:
I supplied this: Microsoft.EntityFrameworkCore.Sqlite and it worked: I got all the models and the dbcontext
But now I need the connection string, what is it??
Sign in to comment
1 answer
Sort by: Most helpful
-
Juan Dent 236 Reputation points
2022-08-24T19:07:01.823+00:00