Entity Framework Core - Knowledge Base (KB)

Entity Framework 6 Programmatically Connect to Postgres

I'm working on programmatically establishing a connection to PostgresSQL using Entity Framework 6. I have this class:...public class ClearspanDatabaseContext : DbContext ...with this constructor:...public ClearspanDatabaseContext() : base(buildConnect...

Connect to external SQL Server through Entity Framework

Basically I need to test a database on an external server (the model matches the model of my local test database)....Here is the connection string I have so far:...<connectionStrings> <add name="DefaultConnection" connectionString="Database=Qu...

How to check connection to database in Entity Framework Core?

In normal entity framework I am able to check the database connectivity using ...dbContext.Database.Exists()... but in Entity Framework Core it is not there. What is the alternative of dbContext.Database.Exists() in Entity Framework Core?

Entity Framework Core connect to MSSQL database over SSH tunnel

I've seen a lot of posts asking similar questions, but none of which solved the issue I have....My setup is as follows:...Remote host with database: reachable on ...127.0.0.1:1433...SSH tunneling: ...L5000 -> 127.0.0.1:1433...When I enter the server name ...

Error on UWP trying to connect to SQL Server Express via EFCore

Team, this is driving me crazy. I always receive this error when I start the UWP application:...Microsoft.Data.SqlClient.SqlException: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not...

Custom connection opening/closing for DbContext

EF Core opens and closes a ...DbConnection... for each query by default, unless you pass in an already-open connection....I have ...lots of small queries..., so instead of opening and closing a connection each time, I'd like to keep the connection open fo...