Content
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; …
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…


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…
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…
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…


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…
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 ?…


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…
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…
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…


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: …


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…


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…


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…


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…
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…
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. …


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…


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…


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…

