Entity Framework Core 2 Migration issue

Question

I am building app using ASP.NET Core 2 and DB part is EF core 2.

i have model like this

public class User        
{
     public int Id { get; set; }
     public string FirstName { get; set; }
     public string LastName { get; set; }   
}

This is context file

public class EFCoreDbContext:DbContext
{
    public EFCoreDbContext(DbContextOptions<EFCoreDbContext> options)
    : base(options)
    {

    }

    public DbSet<ChatMessage> ChatMessages { get; set; }
}

and finally startup.cs

services.AddDbContext<EFCoreDbContext>(options =>
            options.UseSqlServer(Configuration.GetConnectionString("MooltiRoomDatabase")));

And connection string in appsettings.json

"ConnectionStrings": {
    "MooltiRoomDatabase": "Server=DESKTOP-BCQ6IAU\\CHATDB,Database=MultiRoomChat;Trusted_Connection=True;"
  }

Through package manager console i was runing Add-Migration the command completed successfully despite the fact that in DB it did not create corresponding table,after that i've read that i need to run Update-Database command for creating table and when i run this command, i got a error like this

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: 25 - Connection string is not valid)

hujtomi · Accepted Answer · 2018-05-26 20:34:27Z

3

As you can see in the error message, 'Connection string is not valid.' You used "," instead of ";" before the Database.

So now you have:

"Server=DESKTOP-BCQ6IAU\\CHATDB,Database=MultiRoomChat;Trusted_Connection=True;"

But, you should use this:

"Server=DESKTOP-BCQ6IAU\\CHATDB;Database=MultiRoomChat;Trusted_Connection=True;"

answered May 26, 2018 at 20:34

hujtomi

1,6702 gold badges18 silver badges24 bronze badges

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

Comments

Kelson Olson · Accepted Answer · 2018-05-26 20:19:21Z

0

In ASP Net Core there is also a development configuration that gets used. You should notice an icon next to app settings - the "drop down" icon. See if adding your connection string to the development config helps.

Also the way the app settings get accessed has changed so make sure you are writing the correct code to receive the value.

answered May 26, 2018 at 20:19

Kelson Olson

1622 silver badges10 bronze badges

Collectives™ on Stack Overflow

Entity Framework Core 2 Migration issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related