ASP.NET MVC EF Connection String On Somee.com

Question

My connection string on local host is

<connectionStrings>
    <add name="DbModels" 
         connectionString="metadata=res://*/Models.DbModels.csdl|res://*/Models.DbModels.ssdl|res://*/Models.DbModels.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=C:\Users\mcc\Documents\consultations.mdf;integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework&quot;" 
         providerName="System.Data.EntityClient" />
</connectionStrings>

and it's working just fine.

But when I deployed my website to somee.com and tried to update the connection string in the web.config, I failed to get it to work

somee connection string is this:

workstation id=Consultations.mssql.somee.com;packet size=4096;user id=Samer_61122_SQLLogin_1;pwd=///;data source=Consultations.mssql.somee.com;persist security info=False;initial catalog=Consultations

I need to know how should be the proper connection string to work

Ask the somee.com support ?!?

marc_s
– marc_s

2020-06-08 11:04:45 +00:00
Commented Jun 8, 2020 at 11:04 — marc_s
– marc_s, Commented Jun 8, 2020 at 11:04

koding · Accepted Answer · 2020-09-15 23:27:52Z

1

Create your database in somee.com, site will generate a connection string like this:

workstation id=xxxx.mssql.somee.com;packet size=4096;user id=yyyy_SQLLogin_1;pwd=zzzz;data source=xxxx.mssql.somee.com;persist security info=False;initial catalog=xxxx

Try like this for EF:

metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=xxxx.mssql.somee.com;initial catalog=xxxx;persist security info=True;user id=yyyy_SQLLogin_1;password=zzzz;MultipleActiveResultSets=True;App=EntityFramework"

edited Sep 15, 2020 at 23:27

answered Sep 15, 2020 at 23:16

koding

1651 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET MVC EF Connection String On Somee.com

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