Support for adding Aspire SQL Server?

[mikeleigh1010]

It would be helpful if the project could either document or support swapping out from using sql lite to using an aspire configured instance of SQL server.

• .NET SDK Version: 9

Steps to Reproduce:

1.Add configuration for a sql server reference
2.Update reference from UseSqlLite to AddSqlServerDbContext

[ardalis]

Agreed 100%

[benjaminmishra]

@ardalis - I can give this one a try. I have some ideas around how this can be done.

[ardalis]

All yours.
You might look at this related issue:
ardalis/DotNetDataAccessTour#8

[ardalis]

@benjaminmishra any update?

[benjaminmishra]

@ardalis yes, figured out that it can be done using preprocessor directive like syntax
So we can have the following line of code in the InfrastructureServiceExtensions.cs file.

#if (UseSqlServer)
  services.AddDbContext<AppDbContext>(options => options.UseSqlServer(connectionString));
#else
  services.AddDbContext<AppDbContext>(options => options.UseSqlite(connectionString));
#endif

Question: How do we want to expose this as an option ? I was thinking may be we can add some flags while template creation and let the user choose the database type they want to use based on this flag?

choice parameter

[ardalis]

Yes, exactly. A flag during template creation.