Entity Framework Core - Knowledge Base (KB)

The type [Type] exists in both [Assembly1] and [netstandard 2.0 assembly]

I cannot get Microsoft.EntityFrameworkCore 2.0 to work with NETStandard.Library 2.0...Error CS0433 The type 'AttributeUsageAttribute' exists in both 'System.Runtime, Version=4.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' and 'netstandard, Ver...

.NET Standard 2.0 / EntityFrameworkCore / DB2 / IBM.EntityFrameworkCore issue

Does anyone here has experience with ...IBM.EntityFrameworkCore... package? I've created a .NET Standard 2.0 library project in VS2017, added mentioned package, and tried to make it work by following ...this... and ...this... tutorial from IBM website, wi...

Package X is not compatible with netstandard2.0

I created a .NET Standard v2.0 project in Visual Studio 2017 v15.3.1 and I'm unable to install "Microsoft.EntityFrameworkCore 2.0.0" package in it (by Nuget 4.3). Previously the .NET SDK and Runtime, both 2.0.0, were installed....The errors I get follow t...

How to get scalar value from a SQL statement in a .Net core application?

The following code in a .Net core console application (EF core 2.0/Sql server)....var sql = _context.Set<string>() .FromSql("select dbo.FunctionReturnVarchar({0});", id); ...got the following exception?...Cannot create a DbSet for 'string' becau...

Reading app.config from .NET Standard 2.0 library

I'm creating a .NET Standard 2.0 library to be consumed from a .NET Framework 4.6.1 application.... This library needs EF Core, but I can't figure out how to read the app.config....In a .NET Framework library I would initialize my DBContext like this:...p...

Cannot use Entity Framework in .NET standard 2 project

How can I use Entity Framework, or something similar within a .NET Standard project?...It appears as though EF is not supported in .NET Standard 2 which is really annoying!...So I have tried using Microsoft.EntityFrameworkCore.SqlServer and icrosoft.Entit...

Trying to set-up Entity Framework core in .Net Standard project

I was wondering if I could set-up my EntityFrameworkCore in a .NET Standard 2.0 project easily. I was following this ...Tutorial... but it requires either .NET Core or Framework....When I got to this step: ...Scaffold-DbContext "Server=(localdb)\mssqlloca...

Template 10 and netstandard 2.0

I wonder if template 10 is compatible with netstandard2.0. I have a very simple library listed below:...using Microsoft.EntityFrameworkCore; using System; using System.ComponentModel.DataAnnotations; namespace TransactionModel { public class MyTransa...

How to create Autoincrement column in SQLite using EF core?

I am using Entity Framework Core 2.0 for Sqlite code first in my ...UWP and .NET Standard... app. My model has an entity of type Primary Key integer which should be served as auto increment according to ...SQLite documentation.... But in real for every ro...

Using Fluent Api to set foreign key constraint in Entity Framework Core 2.1

We're moving an existing application to .net core 2.1. We currently have a table called ApplicationUser which is referenced by most of the tables in our application because of the audit columns in the tables. ...Given the following tables...ApplicationUs...

Entity Framework Core Migrations In .NETSTANDARD Class Library?

The main issue: Need to update the SQL DB to have new tables because I added new Entities and DB sets in the DataAccess and Entity layers....Okay, my project is laid out like so. Solution > DataAccessLayerProject(DB Context), ModelsProject(Entities), Test...

EF Core 3.1 property is of type 'Nullable<Guid>' which is not supported by current database provider

Moving over from .net Framework EF 6.4, did something similar for years. Just trying to use a Guid datatype with SQL Server db, getting this error - this should just work, right?? If I remove applyconfigurations in the DbContext.OnModelCreating then it w...

How do I expose a .netstandard2.0 library with COM for use in VB6?

I have a dotnet core library, a framework 4.7.2 library and a vb6 application....I want to write a common library for them all to access and so choose .netstandard2.0...I tried a the 4.7.2 framework wrapper library between .netstandard2.0 library and vb6....