Should the name of my connection string should be same as the table name provided in the DB

Question

Though I tried searching many post I din't get the solution. Issue in Entity Framework

Should the name of my connection string should be same as the table name provided in the DB?

Because when I gave the connection string name as the table name, I've not found any errors, but when I gave the DBContext as my connection string name,I got this exception.

An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code

Additional information: The connection string 'ProductContext' in the application's configuration file does not contain the required providerName attribute."

Here is my piece of code Model:

public class Product
    {
        public  int id { get; set; }
        public  string Name { get; set; }
        public int Quantity { get; set; }
        public DateTime EntryDate { get; set; }
    }

ProductContext

 public class ProductContext: System.Data.Entity.DbContext
    {
        public DbSet<Product> Products { get; set; }
        public ProductContext() : base("ProductContext") { }
    }

Controller:

public class ProductController : Controller
    {
        ProductContext db = new ProductContext();
        // GET: Product
        public ActionResult Index()
        {
            var product = db.Products.ToList();
            return View(product);
        }

web.config:

<connectionStrings>
    <add name="ProductContext" connectionString="Data Source=SHUTTHEFCUKUP;Initial Catalog=EntityFrameWork;Integrated Security=True;providerName=System.Data.EntityClient" />
  </connectionStrings>

DB table:

select * from Product
columns:
id,
name,
quantity,
date_entry

Could anyone help me out as I'm new entity framework.I'm missing something.

https://stackoverflow.com/questions/20277677/dynamic-mysql-database-connection-for-entity-framework-6 — ScaisEdge, Jun 14 '17 at 18:25
Are you really using MySQL? Your connection string looks like SQL Server's — Sami Kuhmonen, Jun 14 '17 at 18:25
Possible duplicate of [Dynamic MySQL database connection for Entity Framework 6](https://stackoverflow.com/questions/20277677/dynamic-mysql-database-connection-for-entity-framework-6) — Xavier J, Jun 14 '17 at 18:39

score 1 · Answer 1 · answered Jun 14 '17 at 18:31

Change connection string as shown below,

<connectionStrings>
    <add 
        name="ProductContext" 
        connectionString="Data Source=SHUTTHEFCUKUP;Initial Catalog=EntityFrameWork;Integrated Security=True;"
        providerName="System.Data.SqlClient" />
</connectionStrings>

providerName is an attribute in add node, it is not part of connectionString.

score 0 · Answer 2 · answered Jun 14 '17 at 18:23

0

When your connection string is named after the context it will automatically be used for that context. In this case you must have the providerName attribute set so Entity Framework knows which database connection provider to use.

You should also have a provider setup in the Web.config file with the same name for Entity Framework. This depends on the connector you're using for the database and should be documented in its documentation.

In this case it should be sufficient to add providerName="System.Data.EntityClient" into the string.

answered Jun 14 '17 at 18:23

Sami Kuhmonen

30,146
9
61
74

I have added the providerName,but i am getting the exception – Vijay Vj Jun 14 '17 at 18:28
@VijayVj For one thing, integrated auth isn't going to work with MySQL... – ebyrob Jun 14 '17 at 18:33

Should the name of my connection string should be same as the table name provided in the DB

2 Answers2