Entity Framework 6 - Knowledge Base (KB)
15 results in tag: database-connection
'The underlying provider failed on Open,' says MSSQL.
I was using an ....mdf... for connecting to a ...database... and ...entityClient.... Now I want to change the connection string so that there will be no ....mdf... file....Is the following ...connectionString... correct?...<connectionStrings> <!--<add ...
asked by senzacionale
To code-first DbContext, provide the connection string.
How do I pass a connection string to entity framework's code-first DbContext? My database generation works correctly when both DbContext and the connection string in web.config is in the same project and named the same way. But now I need to move the DbCo...
asked by Shawn Mclean
Entity framework, how to increase limits?
We are building an application which makes every week a very large amount of request over the database, concurrently....We have ~15-20 threads which query the database concurrently....We are actually encountering a lot of problems:...On the database side(...
asked by J4N
Testing an Entity Framework database connection
I have an app that connects to a MYSQL database through the entity framework. It works 100% perfectly, but I would like to add a small piece of code that will test the connection to the database upon app startup....I had the idea of simply running a tiny ...
asked by Steven Wood
The 'data source' keyword is not supported. (ASP.Net app, Entity-framework 5, Code first, migrations)
I have an OData/WCF Data Services endpoint (ASP.Net site) that I would like to switch from using EF Code first datamodel with SQL Server 2012 as backend to EF Code first datamodel with LocalDB as backend - on our dev machines using Visual Studio 2012. Cod...
asked by Jesper Lund Stocholm
unable to retrieve metadata for unrecognized element providers
I get a message error whenever I try to add a controller with Entity framework template but I keep getting a error message... unable to retrieve metadata for 'path' unrecognized element providers. (C:\Users\user\appdata\local\Temp-mp6124.tmp ...
asked by Mohamed Naguib
Entity Framework Connection to localDb
I am trying to follow the pluralsight course ASP.NET MVC 4 Fundamentals. But can't have my database connected....Here is the error I got: ...An error occurred while getting provider information from the database. This can be caused by Entity Framework usi...
asked by tooold
Connection string works for Entity framework but fails on bulk
The problem I am having is that in the Web.Config, I have a connection string which db.database is using, this works fine, I am able to retrieve data from the database no problem, however the problem I am having is when I try to use SqlBulkCopy:...using (...
asked by user2836518
Can't connect to MySql database with Entity Framework 6
Installed via NuGet: MySql.Data, MySql.Data.Entities, MySql.Data.Entity....Web.config:...<connectionStrings> <add name="WhateverEntities" providerName="MySql.Data.MySqlClient" connectionString="server=127.0.0.1;port=3306;database=dbname;uid=root;passwor...
asked by Tomo
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...
asked by Nick Gilbert
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...
asked by JensOlsen112
Cannot connect to Sql Server from Visual Studio (in the process of creating a new Entity Data Model): login failed for user 'sa'
I know there are similar questions, but I have a specific problem....Microsoft Visual Studio (2017)... pops up this error when I try to create a DB connection for my ...Entity Data Model...The attempt to attach to the database failed with the following ...
asked by AlexMelw
Entity Framework not using updated connection string
Is it possible to change the connection string within the app.config file and have Entity Framework start using the new values?...I have a multi-threaded app with one thread acting as the dispatcher. This thread has the ability to receive a message telli...
asked by Mark Wagoner
Is there a way to log traffic to and from SQL Server Browser?
Something strange is happening with a database server I had to rebuild and restore from backup....I'm pointing an old VB6 application using ADODB.Connection and a modern C# EF6 application at it, using what should be the same connection string for both, o...
asked by Glazius
Use DBContext with Oracle
I have searched the web and reviewed similar questions on Stack Overflow but I can not figure how to use the Oracle Managed Data Provider with a DbContext from a C# .Net 4.6 Console Application....This works for Sql Express ...class SqlDBContext1 : DbCont...
asked by vscoder
