Access existing connection string in web.config to new .NET Core Web API

ASP.NET 5/EF7 connection string in web.config?

You can do something like this to pull in configs from different *.json files, the following bases them on environment, or from environment variables;...var builder = new ConfigurationBuilder() .AddJsonFile("appsettings.json") .AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true); .AddEnvironmentVariables(); ...You can...

.net SqlClient and .NET CORE Web API connection string

Maybe it's a syntax problem:...Data Source=Server\\Instance ...If you have a default instance, then, only use:...Data Source=Server

How to stop self-referencing loop in .Net Core Web API?

Okay... I finally found some reference material on this. The solution is:...public void ConfigureServices(IServiceCollection services) { ... services.AddMvc() .AddJsonOptions( options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore ); ... } ...I got this f...

.net Core 2.0 Web API - Newtonsoft.Json.JsonSerializationException - IQueryable

It cannot create an interface because doesnot know which type it actually should use. Try:...JsonConvert.DeserializeObject<List<OhaMedication>>(stringData).AsQueryable()

The specified deps.json [path\App.Web.Site\App.Web.deps.json] does not exist

I have the same problem after I updated Visual Studio to 16.1.3. Create new project, run it, stop debug, then I read the following in Package Manager Console:...PM> add-migration -v initial Using project 'TestEf2'. Using startup project 'TestEf2'. Build started... Build succeeded. C:\Program Files\dotnet\dotnet.exe exec --depsfile G:\testef\TestEf2...

EF Core connection string settings with azure functions and web api

For Local Development use an ...Environment Variable... to store your connection string. (Right click your ...Azure Function Project... in ...Visual Studio... select ...properties..., ...Debug... and you will be able to add an ...Environment Variable... there. This will be stored in ...launchsettings.json...) For example you could call it ...MSSQL...

.Net Core 2.2 web api with Entity Framework and Linq not able to do async tasks?

Don't use ...Task.FromResult... where you are, because that will cause your live code to run synchronously (when you feed ...await... a completed ...Task..., which ...Task.FromResult... does, everything runs synchronously). That will hurt your code in production....Microsoft has documentation on how to deal with this in EF6 ...here..., although it ...

How to disable windows authentication only for Web API inside a .net core MVC web application

After spending several hours I have found the following solution: In launchsettings.json set following values..."iisSettings": { "windowsAuthentication": true, "anonymousAuthentication": true, ...Add the following line inside startup.cs ConfigureServices...services.AddAuthentication(IISDefaults.AuthenticationScheme); ...add ...[Authorize] ...attr...

Creating a .NET Core web api that has a route access to an existing Database

So I assume you are trying to create all the classes based on your existing database....This is done with the ...Scaffold-DbContext... command. You can use it manually as described ...here..., but I prefer to use the ...EFCorePowerTools... plugin. Use the ...Reverse Engineer... feature, which will generate and run the appropriate ...Scaffold-DbCont...

EF Core migration error with .NET Core Web API in Visual Studio Code

Thank you @sea_ocean ... You have to specify the startup project:...dotnet ef migrations add MigrationOne --startup-project ../Sample.API/Sample.API.csproj ...and then...dotnet ef database update --startup-project ../Sample.API/Sample.API.csproj ...You also need to install Microsoft.EntityFrameworkCore.Design to the startup project