alternative method for database connection in .net core web api

Question

alternative method for database connection in .net core web api

Mahadevi Thirumagan 0

In .NET Core Web API, linking to and managing an existing database is more complex than in .NET Framework. I need a way to add existing tables to models and a simple method to connect, update, and alter tables. Any straightforward approach?

Pradeep M 8,965 Reputation points Microsoft External Staff Moderator

2024-07-30T04:03:43.0233333+00:00

Hi Mahadevi Thirumagan,

Just checking in to see if you had a chance to review the response provided by AgaveJoe to your question. If it was helpful, please let us know by accepting the answer and upvoting it. Don't hesitate to reach out to us if you face any issues.

1 answer

Your answer

Pradeep M 8,965 Reputation points Microsoft External Staff Moderator

2024-07-30T04:03:43.0233333+00:00

Hi Mahadevi Thirumagan,

Just checking in to see if you had a chance to review the response provided by AgaveJoe to your question. If it was helpful, please let us know by accepting the answer and upvoting it. Don't hesitate to reach out to us if you face any issues.

Answer 1

AgaveJoe 30,041

I need a way to add existing tables to models and a simple method to connect, update, and alter tables. Any straightforward approach?

A simple CLI command generates C# models from tables in EF Core.

https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding/?tabs=dotnet-core-cli

Likewise, scaffolding Web API controllers can be done with a CLI command or in Visual Studio.

https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-8.0&tabs=visual-studio

Share via

alternative method for database connection in .net core web api

1 answer

Your answer