I want to scaffold dbcontext efcore in .net 6 web API from Azure Sql Database

SURYA LAKKOJU 21

Hello,

I have an issue, i'm trying to create models from my existing database which is a azure sql database. now when i run the below command it is giving me object reference not set to an instance error and I don't know what exactly I'm passing as null, one more thing we have azure ad authentication to access database with our accounts. no static passwords.

I have tried to run the below commands and none of them worked and gives me some sort of errors.

Scaffold-DbContext "Data Source=tcp:AzureTestdb.database.windows.net,1433;Authentication=Active Directory Default;Database=Department;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Scaffold-DbContext "Data Source=tcp:AzureTestdb.database.windows.net,1433;Authentication=Active Directory Integrated;Database=Department;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Scaffold-DbContext "Data Source=tcp:AzureTestdb.database.windows.net,1433;Authentication=Active Directory Interactive;Database=Department;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Scaffold-DbContext "Server=tcp:AzureTestdb.database.windows.net,1433;Initial Catalog=Department;Authentication=Active Directory Default;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

can anyone please help me how to setup this scaffold in my visual studio to create models from azure sql database. below is the error i'm getting

Please help me to scaffold the models, thanks in advance.

ShaktiSingh-MSFT 13,516 Reputation points Microsoft Employee

2022-12-01T08:56:08.66+00:00

Hi @SURYA LAKKOJU ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

As I understand from the question, you want to know how to setup this scaffold in my visual studio to create models from azure sql database.

I would recommend you to go through this detailed video illustrating the same: Creating Scaffold Models in Visual Studio

Scaffold Existing Database - Entity Framework Core

Please follow the steps and let know if this helps. If you face issues, please let us know.
SURYA LAKKOJU 21 Reputation points

2022-12-02T04:03:29.387+00:00

The above provided url din't help those are using local sql server instance to scaffold the tables as models into the visual studio, but as i'm trying to create the models from Azure SQL database and when I tried to use the scaffold command above mentioned it is giving me errors, I've provided the possible types of connection strings I've tried to create the scaffold models using entity framework, but none of them worked. Please let me know whether entityframework does support the scaffold option for Azure SQL database?
ShaktiSingh-MSFT 13,516 Reputation points Microsoft Employee

2022-12-02T04:25:56.347+00:00

Hi @SURYA LAKKOJU ,

Thanks for the reply. I will check on this question internally and will update you.
ShaktiSingh-MSFT 13,516 Reputation points Microsoft Employee

2022-12-05T06:27:30.927+00:00

Hi @SURYA LAKKOJU ,

Just an update that I have asked internal team about this ask and awaiting their reply.

Thanks for your patience.
ShaktiSingh-MSFT 13,516 Reputation points Microsoft Employee

2022-12-05T09:16:46.253+00:00

Hi @SURYA LAKKOJU ,

I have checked internally, and it seems a connection string issue. If you want to use AAD interactive, this is the format you must use:

“Server=tcp:<servername>.database.windows.net,1433;Initial Catalog=<dbname>;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication=Active Directory Interactive;”

Please retry and let us know if this helps.
ShaktiSingh-MSFT 13,516 Reputation points Microsoft Employee

2022-12-06T09:30:03.447+00:00

Hi @SURYA LAKKOJU ,

Just checking if the above suggestion helped. If further queries, do let us know. Thanks