Microsoft Q&A

Entity Framework Core

420 questions

A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.

Browse all .NET tags

420 questions with Entity Framework Core tags

Sort by: Answers
9 answers

EF Core - updated data retrieve problem

Hello, I am trying to get updated data like this in my Blazor Server application: async Task PassiveDetail(OrderDetail orderDetail) { if (orderDetail == _detailToInsert) { _detailToInsert = null; …

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
783 questions
asked 2022-09-16T05:37:57.627+00:00
Cenk 666 Reputation points
answered 2022-09-21T20:10:41.32+00:00
Cenk 666 Reputation points
9 answers

How To Populate A dropdown feature In Ef core razor pages

hi , I made a department class.. And I have also A ApplicationUser class responsible for registering a user. While Registering a User I want A department Dropdown Feature Should be Populated From Database . I am new in this field so can Anyone suggest…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2022-06-27T08:56:12.887+00:00
Arnab 61 Reputation points
commented 2022-07-07T08:08:03.163+00:00
Zhi Lv - MSFT 18,461 Reputation points Microsoft Employee
7 answers

How to publish my Net Core 6 website on my Windows Server 2022 and link а domain name to it?

HI! How can I publish my Net Core 6 website on my Windows Server 2022 and link а domain name to it? Does anyone have links to an approximate sequence of actions? I raised IIS on Windows Server 2012 R2 a long time ago, but then I had Apache HTTP…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
Internet Information Services
asked 2022-10-08T09:30:26.303+00:00
Volk Volk 221 Reputation points
answered 2022-10-10T19:23:15.47+00:00
Volk Volk 221 Reputation points
7 answers

Use FileTable / .NET Core application class model

Hi, I would like some advise about the schema that I would to implement to my .Net App. I want to use FileTable with my .NET Core application where I must create a relationship of this FileTable with another simple table (e.g Document.cs) Schema : 1…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,922 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2022-05-19T20:29:11.483+00:00
sblb 831 Reputation points
commented 2022-05-26T14:53:01.917+00:00
sblb 831 Reputation points
6 answers

What are the pros and cons of using stored procedures vs C# code for DB work?

If there is a better place to post them please advise. Based on the available tags I feel as if I'm not in the correct forum. My company has a long history of using stored procedures for even the most trivial of db queries. I am trying to convince…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,475 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,922 questions
asked 2021-01-19T22:07:49.4+00:00
Bernzweig, Bruce 96 Reputation points
commented 2022-10-25T21:37:06.66+00:00
Uchenna Nwosu 1 Reputation point
6 answers One of the answers was accepted by the question author.

How do I check the password entered by the user? BCrypt.HashPassword(password) does not match with BD.AspNetUsers.PasswordHash.

Hello! I have a website where users register. A user password is saved as a hash in BD.AspNetUsers.PasswordHash. I have a separate proxy server that needs to verify the password entered by the user from another application. I connect to the…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2022-07-24T21:29:11.553+00:00
Volk Volk 221 Reputation points
accepted 2022-07-27T09:57:13.12+00:00
Volk Volk 221 Reputation points
6 answers One of the answers was accepted by the question author.

What is the preferable way to call a stored procedure in an async await way ?

Hi, I am migrating from EF 6 to EF Core 6. Now the first thing , I need to know is to migrate my Stored Procedure call . How can I create an utility/extension method to call a Store Procedure in an Async Await way with in and out type parameters ?…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2022-04-14T08:19:02.337+00:00
mehmood tekfirst 766 Reputation points
accepted 2022-04-18T11:03:46.43+00:00
mehmood tekfirst 766 Reputation points
5 answers

SQL Bulk Insert Problem while inserting excel data

Hi guys, In my Blazor Server application, I am trying to insert excel data into a SQL database table. I am getting this error, but couldn't figure out why. Hope you can help me. Error: The given ColumnName 'PID' does not match up with any column in data…

Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
783 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,475 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,922 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2023-01-18T11:41:22.24+00:00
Cenk 666 Reputation points
commented 2023-01-19T06:33:23.6533333+00:00
Cenk 666 Reputation points
5 answers One of the answers was accepted by the question author.

Entity model design recommendation needed

Hello there, I am working on an ASP.NET Core Blazor Server application. It is a sort of order management system. Trying to follow clean architecture design. In the core business, there are entities like orders, suppliers, and clients. Each one of…

Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
783 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2022-06-21T19:50:54.317+00:00
Cenk 666 Reputation points
answered 2022-06-22T10:42:24.433+00:00
Cenk 666 Reputation points
5 answers

SQL Server test databases fail when multiple databases open

I'm working on an intermittent issue experienced with: Entity Framework Core 3.1, C# SQL Server 2019 Unit tests (xUnit) Tests: * About 2000 tests total * About 150 tests which exercise system elements using SQL Server database, each test…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,475 questions
asked 2022-03-22T20:53:30.793+00:00
Paul Tobey 1 Reputation point
answered 2022-03-25T15:13:51.387+00:00
Paul Tobey 1 Reputation point
5 answers One of the answers was accepted by the question author.

Using PaginatedList with ViewModel (ASP.NET Core 5.0, C#, EntityFramework)

I'm creating a Frequently Asked Questions web application. I followed Microsoft's tutorial for adding sorting, filtering, and paging to an ASP.NET MVC EF Core application, using the PaginatedList: …

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
ASP.NET MVC
ASP.NET MVC
A Microsoft web application framework that implements the model-view-controller (MVC) design pattern.
582 questions
asked 2021-06-03T15:48:32.613+00:00
Anna Tamaoka 136 Reputation points
accepted 2021-06-09T15:58:24.093+00:00
Anna Tamaoka 136 Reputation points
4 answers

SQLAzure is not available for your selection of subscription and location

Hi Folks, Trying to use Azure for the first time, I'm using a normal account (i.e not free tier or student) but it is just for a hobby project. I'm following the tutorial here in order to deploy my EFCore webapi…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
Azure Web Apps
Azure Web Apps
A feature of Azure App Service used to create and deploy scalable, mission-critical web apps.
4,306 questions
Azure SQL Database
asked 2023-01-22T08:33:29.6833333+00:00
Gary Frewin 5 Reputation points
answered 2023-01-24T04:45:49.5733333+00:00
Joshua Davies 1 Reputation point
4 answers

Porting Entity Framework 6 to Entity Framework Core

I am porting an application from ASP.net MVC 5 to ASP.net Core MVC and I reach out in the area pointing the Entity Framework related modules. I have the generated classes and I also have the edmx and tt files, I added the files to a newly created Class…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
ASP.NET MVC
ASP.NET MVC
A Microsoft web application framework that implements the model-view-controller (MVC) design pattern.
582 questions
Entity Framework 6.0
Entity Framework 6.0
A Microsoft open-source object-database mapper for .NET.
216 questions
asked 2023-01-20T16:28:32.4533333+00:00
cebuhax0r 21 Reputation points
answered 2023-01-22T14:35:37.99+00:00
Karen Payne MVP 29,226 Reputation points Microsoft MVP
4 answers

How do I Test Controller HTTP Methods with Nunit test?

namespace CoreWebApi.Controllers { [Route("api/[controller]")] [ApiController] public class DataPrizeController : ControllerBase { private readonly PrizeService service; private readonly…

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,922 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
.NET Standard
.NET Standard
A formal specification of .NET APIs that are available on multiple .NET implementations.
482 questions
asked 2022-07-27T04:40:37.587+00:00
Sarwar Akbar 26 Reputation points
answered 2022-07-27T13:46:34.837+00:00
AgaveJoe 17,021 Reputation points
4 answers One of the answers was accepted by the question author.

Could not load file or assembly class library "Microsoft.EntityFrameworkCore version = 6.0 in Class Library

Hello everyone and thanks for the help in advance. I have two problems intelrinked with each other. First, I am creating for the first time a C# class library in .Net 6 that is a data access layer for other apps. I have never created a class library…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
.NET CLI
.NET CLI
A cross-platform toolchain for developing, building, running, and publishing .NET applications.
289 questions
asked 2022-06-28T00:25:56.403+00:00
Kmcnet 201 Reputation points
accepted 2022-07-03T18:27:41.497+00:00
Kmcnet 201 Reputation points
4 answers One of the answers was accepted by the question author.

Does package microsoft.entityframeworkcore.sqlserver work with xamarin.forms?

I am getting an error when trying to connect. I am only testing with the xamarin.ios project. I realize that connecting to a sql database over the internet is not a good idea. However, in my case the application connects only to a local database on a…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
Xamarin
Xamarin
A Microsoft open-source app platform for building Android and iOS apps with .NET and C#.
4,804 questions
asked 2020-11-27T23:04:26.477+00:00
Kurt K 76 Reputation points
commented 2021-04-18T01:51:52.777+00:00
Kurt K 76 Reputation points
4 answers One of the answers was accepted by the question author.

How to pass datatable from c# class to MSSQL Server stored procedure using Entity Framework Core 5.0.1.

I have a data import application written in .Net Framework to migrate to .Net Core. The application uses a c# class to pass a datatable as an input parameter to a MSSQL server stored procedure. The code in EF6 works fine and is pasted below. …

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2020-12-10T12:53:30.587+00:00
Williamson, Stephen 21 Reputation points
accepted 2020-12-14T15:19:11.56+00:00
Williamson, Stephen 21 Reputation points
3 answers One of the answers was accepted by the question author.

EF Core 6 - DateTime how to set null

Hi, I am trying to set null to a datetime field but unfortunately it is not setting null. public async Task UpdateOrderDetailAsync(OrderDetail orderDetail) { var detail = await…

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,922 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2023-01-02T17:50:14.69+00:00
Cenk 666 Reputation points
commented 2023-01-03T22:41:49.423+00:00
Arharbi, Adnane 131 Reputation points
3 answers

LINQ question in .NET 6 EF CORE conversion

I currently have a .NET 4 WebAPI using Entity Framework 3 that I'm upgrading to .NET 6 EF CORE. I currently have a LINQ Query that looks like this (and works fine) [HttpGet] public async Task<ActionResults> GetCars() { var x = from f…

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,922 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
asked 2022-11-21T18:11:17.843+00:00
Cloud Developer 1 Reputation point
commented 2022-11-29T07:52:49.113+00:00
Jack J Jun 19,046 Reputation points Microsoft Employee
3 answers

Why isn't my WCF/WPF service working?

This is my structure and what I did: WCF add Entity Framework IService add [OperationContract] in IService1 create DTO classes for things I needed Service in Service1 create class variable "Entity entity= new…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,173 questions
Windows Communication Foundation
Windows Communication Foundation
A Microsoft runtime and set of application programming interfaces in the .NET Framework for building service-oriented applications.
258 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
1,175 questions
asked 2022-09-10T08:37:21.763+00:00
Anonymous
answered 2022-11-08T06:56:45.673+00:00
ElChefe 76 Reputation points