Last post Jan 20, 2021 06:56 PM by pmarchdev
Jan 20, 2021 06:37 PM|pmarchdev|LINK
I have created a user web form (asp.net Core) to update a table (Add, Edit, Delete records) in SQL Server using Visual Studio 2019. I had the form functioning properly testing it using the MSSQLLocalDB Connection, however I am having difficulty connecting
to my Live SQL Server data source. I have defined the connection string in "appsettings.json", called the connection string in the "startup" page. I have built the solution, no errors or warnings, but I'm not quite sure where to go from there.
Thanks for your help
Jan 20, 2021 06:49 PM|mgebhard|LINK
Can you contact support for your Live SQL Server? I'm not sure how this forum can help you connect to an unknown database. Maybe the problem is running code first migrations on the new DB?
Jan 20, 2021 06:56 PM|pmarchdev|LINK
The application ran fine and produced the pages as expected using the MSSQL Local DB Connection created when setting up the application in Visual Studio. I'll see if I can find a Visual Studio forum for additional help. Thank you.