how to connect asp.net core MVC project to local DB using Entity Framework Core on ubuntu desktop

asp.net-core c# entity-framework-core sql-server ubuntu-16.04

Question

I'm Building an asp.net core application using Entity Framework Core on Ubuntu 16.04 desktop. I have SQL Server installed and running. I've run the command "-dotnet ef migrations Initial" successfully. I'm prepared to run "-dotnet ef database update" to allow EF to connect to and create the table in the database but I'm receiving this error on the terminal:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 25 - Connection string is not valid)

it's a local DB so I'm thinking I don't need a TCP provider, right? how do I tell EF to connect to SQL server?

1
1
7/27/2017 4:39:09 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Specify your connection string on appsettings.json file 

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=YOUR_SERVER_NAME;Database=DBNAME;User Id=sa;Password=PASSWORD;Trusted_Connection=True;MultipleActiveResultSets=true"
  },
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Warning"
    }
  }
}
2
7/28/2017 6:20:04 AM

Related Questions

How to Read Record From Database in ASP.MVC Core using Entity Framework Core 1.0

My Fault found error, was giving wrong table name in override OnModelCreating...public class TestDbContext: DbContext { public TestDbContext(DbContextOptions<TestDbContext> options): base(options) { } public DbSet<TestModel> TestModels { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { m...
asp.net-core-mvc c# entity-framework-core sql-server-2014
asked by Toxic

Seed roles in an ASP.NET MVC Core project with Entity Framework

using Microsoft.AspNetCore.Identity; using Microsoft.AspNetCore.Identity.EntityFrameworkCore; using Microsoft.Extensions.DependencyInjection; public static class Seed { public static void Initialize(IServiceProvider provider) { var _context = provider.GetRequiredService<ApplicationDbContext>(); var userManager = provider.Ge...
asp.net-core-mvc c# entity-framework-core
asked by mvermef

Register EF Core using IDbContextFactory in ASP.NET Core Mvc

Instead of ....AddDbContext(typeof(...))... provide a factory method to create context:...services.AddTransient(provider => { //if needed: anything from DI var bar = provider.GetService<TBar>(); //if needed: external captured variable doSomething(service); //explicit context creation return new FooDbContext(...); });
asp.net-core-mvc c# entity-framework-core
asked by Ilya Chumakov

Multiple tenants with Entity Framework Core and SQL Server 2017 in ASP.NET Core application

Yea, it depends on your application....I'd go with 1. ...some tables (client defines on setup which one) must be shared between tenants, for example: it has common tables for users, groups, rights, user-settings, but separate for offers, prices, events...If you need tables for settings, user management, groups, rights, etc you should create a s...
asp.net-core entity-framework entity-framework-core sql-server sql-server-2017
asked by Razvan Dumitru

Dependency Injection failing in ASP.NET Core MVC and Entity Framework Core

Dependency injection is a technique for achieving inversion of control it is majorly to inject a service into the constructor of the class where it will be used....Basically, you inject a service from an interface it implements. for instance...If you have an interface...public interface IMyInterface { void doMyWork(); } ...And then you had a s...
asp.net-core-mvc c# entity-framework-core razor
asked by Bosco

How to install entity framework core to asp.net core 3 project using visual studio code

ASP.NET Core 3.0 removes some assemblies that were previously part of the ...Microsoft.AspNetCore.App... package reference....You should add the package references for removed assemblies....In XML project file:...<Project Sdk="Microsoft.NET.Sdk.Web"> <PropertyGroup> <TargetFramework>netcoreapp3.0</TargetFramework> <UserSecretsId>My-secre...
asp.net-core c# entity-framework-core visual-studio-code
asked by overcomer

Problem running project after Identity scaffolding in ASP.NET Core MVC project on Linux

I solved the problem by reinstalling: .Net Core SDK 3.1.101 and ASP.NET Core Runtime 3.1.1...https://dotnet.microsoft.com/download/dotnet-core/3.1
asp.net-core-identity asp.net-core-mvc c# entity-framework-core razor-pages
asked by Alexandar Trenchev

ASP.NET Core MVC Entity Framework Core: the context type 'DatenbankKontext' only declares a parameterless constructor

The error is telling you that you need to add a constructor that takes options....'DatenbankKontext' should declare a constructor that accepts a DbContextOptions and must pass it to the base constructor for DbContext....So add one:...public class DatenbankKontext : DbContext { public DatenbankKontext(DbContextOptions options) : base(opt...
asp.net-core entity-framework-core
asked by crgolden

Unable to send array data using ajax with ASP.NET Core and Entity Framework Core

You can pass the list of objects by :...$.ajax({ type: "POST", url: "Reception/PatientTests/SavePendingTest", data: { pendingTestResult: tests }, headers: { "RequestVerificationToken": $('input[name="__RequestVerificationToken"]').val() }, success: function (data) { alert(data); }, error: function (e) { ...
asp.net-core asp.net-core-2.0 asp.net-mvc entity-framework-core
asked by Nan Yu

Caching entity itself in IMemoryCache in ASP.NET Core MVC with Entity Framework

This i very basic usage of memory cache, it can meet some basic requirement, but please consider below senario...Your POCO is changed by someone else, how would your cache know that? You'll need some sync task to sync your cache and database data...Your application is going to be delpoyed to a web farm, memery cache only works for just one machine,...
asp.net-core-mvc caching entity-framework-core
asked by Elendil Zheng-MSFT

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow