keyword not supported data source

by

What you have is a valid ADO.NET connection string – but it’s NOT a valid Entity Framework connection string.

The EF connection string would look something like this:

<connectionStrings> 
  <add name="NorthwindEntities" connectionString=
     "metadata=.\Northwind.csdl|.\Northwind.ssdl|.\Northwind.msl;
      provider=System.Data.SqlClient;
      provider connection string=&quot;Data Source=SERVER\SQL2000;Initial Catalog=Northwind;Integrated Security=True;MultipleActiveResultSets=False&quot;" 
      providerName="System.Data.EntityClient" /> 
</connectionStrings>

You’re missing all the metadata= and providerName= elements in your EF connection string…… you basically only have what’s contained in the provider connection string part.

Using the EDMX designer should create a valid EF connection string for you, in your web.config or app.config.

I understand what you’re trying to do: you need a second “ADO.NET” connection string just for ASP.NET user / membership database. Your string is OK, but the providerName is wrong – it would have to be “System.Data.SqlClient” – this connection doesn’t use ENtity Framework – don’t specify the “EntityClient” for it then!

<add name="ASPNETMembership" 
     connectionString="Data Source=MONTGOMERY-DEV\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True;" 
     providerName="System.Data.SqlClient" />

If you specify providerName=System.Data.EntityClient ==> Entity Framework connection string (with the metadata= and everything).

If you need and specify providerName=System.Data.SqlClient ==> straight ADO.NET SQL Server connection string without all the EF additions

More Related Contents:

  1. One DbContext per request in ASP.NET MVC (without IOC container)
  2. Why LINQ to Entities does not recognize the method ‘System.String ToString()?
  3. Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations
  4. using stored procedure in entity framework
  5. Should services always return DTOs, or can they also return domain models?
  6. ASP.NET MVC3 and Entity Framework Code first architecture
  7. How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser
  8. Saving Many to Many relationship data on MVC Create view
  9. Defining multiple Foreign Key for the Same table in Entity Framework Code First
  10. ‘Microsoft.SqlServer.Types’ version 10 or higher could not be found on Azure
  11. Converting flattened hierarchical data from SQL Server into a structured JSON object with C#/Linq
  12. Entity Framework Include OrderBy random generates duplicate data
  13. Use Entity framework I want to include only first children objects and not child of child(sub of sub)
  14. Model backing a DB Context has changed; Consider Code First Migrations
  15. Incompatible Data Reader Exception From EF Mapped Objects
  16. There is already an object named ‘AspNetRoles’ in the database
  17. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
  18. The type or namespace name ‘DbContext’ could not be found [closed]
  19. EntityType ‘Category’ has no key defined. Define the key for this EntityType [duplicate]
  20. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]
  21. Entity Framework change connection at runtime
  22. What is an MVC child action?
  23. Including an anchor tag in an ASP.NET MVC Html.ActionLink
  24. How to fix: Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list
  25. Redirect / show view after generated file is dowloaded
  26. How to remove ASP.Net MVC Default HTTP Headers?
  27. Html helper for
  28. Can I pass an anonymous type to my ASP.NET MVC view?
  29. How to create file and return it via FileResult in ASP.NET MVC?
  30. View Model IEnumerable property is coming back null (not binding) from post method?

Leave a Comment