SQL Error Entity Framework Code First Approach

Question

I am having troubles connecting to SQL database in code first approach. Details are as below

<connectionStrings>
    <add name="MydbConn"
connectionString="Data Source=hostname\SQLEXPRESS;Initial Catalog=Test1;UserID=****;Password=****;Integrated Security=True"
providerName="System.Data.SqlClient"/>
  </connectionStrings>

Below is the Context Helper

public class DBContext:DbContext
    {
        public DBContext():base("MydbConn")
        {
            Database.SetInitializer<DBContext>(new CreateDatabaseIfNotExists<DBContext>());
        }
        public DbSet<User> User { get; set; }
    }

The User Model

public partial class UserChatLog
    {
        [Key]
        public long UserLogId { get; set; }
        public string EnterpriseId { get; set; }
    }

And Finally DBHelper file

public void Save(User user)
        {
            DBContext context = new DBContext();
            context.User.Add(User);
            context.SaveChangesAsync();
        }

I am getting the below exception

System.Data.SqlClient.SqlException: 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. The specified LocalDB instance does not exist.

SQL Express requires the file to be local. Are you trying to use localdb, or a full instance of SQL? — Eris
– Eris, Commented May 19, 2017 at 16:51
I tried everything with the connection string. Could you please help me identify the issue — siddhartha bhardwaj
– siddhartha bhardwaj, Commented May 19, 2017 at 16:51
I am trying to create Database based on my context on my local SQL 2014 server — siddhartha bhardwaj
– siddhartha bhardwaj, Commented May 19, 2017 at 16:52

Munzer · Accepted Answer · 2017-05-19 17:17:16Z

1

Assuming that your connection string is fine, this might be the problem. I think your base constructor is taking ("MydbConn") as database name For specifying connection string in the base constructor i believe this is the right way base("name=MydbConn")

answered May 19, 2017 at 17:17

Munzer

2,3282 gold badges21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Error Entity Framework Code First Approach

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related