ConnectionString Builder in Entity Framework Core 2

Question

I'm trying to convert an old project c# to asp net core and to the EF core 2.0 and I can't find the EntityConnectionStringBuilder.

public string GetEntityConnectionString(string databaseName, string metadata)
{
    string providerName = "System.Data.SqlClient";
    string providerString = GetConnectionString(databaseName);


    System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder entityBuilder =
    new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder();

Error CS0234 The type or namespace name 'Entity' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

Evk · Accepted Answer · 2018-02-21 11:53:23Z

2

That's because EF Core does not support what was known "database first" approach of older EF versions, so there are no edmx files, and so there is no use for EF specific connection strings (metadata=res:... < this kind of connection strings). From that it follows that there is no use for EntityConnectionStringBuilder class, which is used to create such connection strings.

So when porting, just remove your whole GetEntityConnectionString method and use your GetConnectionString instead, together with UseSqlServer, UsePgsql and similar methods.

answered Feb 21, 2018 at 11:53

Evk

102k8 gold badges156 silver badges204 bronze badges

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

Comments

Igorgy · Accepted Answer · 2018-02-21 11:42:49Z

0

You may set connection on Context. Try override OnConfiguring method:

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

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer("Data Source=127.0.0.1;Initial Catalog=DBName;User ID=user;Password=pwd;Connection Timeout=60");
        }
    }

answered Feb 21, 2018 at 11:42

Igorgy

16910 bronze badges

Collectives™ on Stack Overflow

ConnectionString Builder in Entity Framework Core 2

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