Entity Framework Core

0 answers

EF Core query for a specific condition in related entities and update parent entity

Hello there, In my Blazor Server application, I have Order and Order Details entities which are related as you can imagine. They both have their own repositories. public class Order { public int Id { get; set; } [Required] …

asked

Cenk 686

edited a comment

AgaveJoe 17,296

1 answer

EF Core 6 - Adding records based on a condition

Hi friends, In my Blazor server application, I am inserting BulkPurchaseRequest records into DB as follows. public class BulkPurchaseRequestsRepository : IBulkPurchaseRequestsRepository { private readonly OyunPalasContext _oyunPalasContext; …

asked

Cenk 686

commented

Cenk 686

1 answer

4.6.1 migrating to .Net Core 7 – How do I resolve error MC1000- cannot find type System.Management.Instrumentation.InstrumentedAttribute in Assembly ..path \.nuget\packages\system.management\7.0.0\lib\net6.0\SystemManagement.dll – Microsoft.WinFx.Targets

I am migrating a .netFramework 4.6.1 application to core. I have been able to get rid of all of the build errors except this one: Error MC1000 Unknown build error, 'Could not find type 'System.Management.Instrumentation.InstrumentedAttribute' in…

asked

Dozier, Fletcher [US] (DS) 1

answered

Hardik Patel 0

1 answer

I can't use class on layered architecture

I'm working on a web.api for library otomation project. I'm using layered architecture on project. a485553e-89a6-4fa9-8dd5-1c40de6d40e2.jpg image is my architecture. I couldn't access User.cs class on DataAccess layer. I defined with "usign"…

asked

ömercan künye 0

commented

Viorel 82,911

3 answers

EF Core - Getting records randomly based on a certain criteria

Hi there, I would like to get data one by one (TOP 1) where all the statuses of all related BulkID = 1 randomly. Here is what I tried but didn't work as I wanted. Select TOP 1 BulkId, ProductCode from BulkPurchases where status = 1 group by…

asked

Cenk 686

answered

打玻璃 1,526

4 answers

Deserialising a Json string throwing error in razor pages.

Hi , I have a jsonresult like shown below "{\r\n "AccessRights": [],\r\n "ADAttributes": [\r\n {\r\n \ "AD": "teenajohn",\r\n \ "ADFull": "",\r\n …

asked

Blooming Developer 196

answered

Bruce (SqlWork.com) 28,276

0 answers

Entity Framework 框架问题

dbcontext不同的实例，savechanges被互相影响怎么回事

asked

赐张 0

commented

Jack J Jun 19,376 Microsoft Employee

2 answers

EF Core 6 Adding a table manually?

Hello friends, I am working on a web API project that I implemented with the code-first approach. I wonder if there is a problem creating tables manually without using migrations. Does it cause any problems? Thank you.

asked

Cenk 686

commented

Cenk 686

1 answer

Executing Stored Procedures based on condition in Razor Pages

Hi, I have a function that executes two stored procedures based on a condition. Stored procedure for the first condition works fine, but stored procedure for the second condition fails. public async Task<JsonResult>…

asked

Blooming Developer 196

answered

Blooming Developer 196

1 answer

JSON Format WebAPI Entity Framework

Currently the JSON I'm using looks like this: The JSON file is huge so I'm only showing the first few rows in the file so not all data is shown. I'd like to get this JSON structured so I can use in a TreeView menu so I'd like to see get the out put to…

asked

TheCoder 91

commented

Lan Huang-MSFT 9,281 Microsoft Employee

2 answers

Duplicate primary key name when running Update-Database

I am using EF Core 7, with LIve Migrations enable in a code first project. I have a model using TPT strategy. When I generate the model, it gives me the error: Failed executing DbCommand (10ms) [Parameters=[], CommandType='Text',…

asked

José Luiz Berg 0

answered

José Luiz Berg 0

0 answers

EF Core 7 - System.InvalidOperationException

Hi, Can someone please help? I am trying to insert a record with an FK using DBContext. EF Core keeps saying that the Country is already tracked. I am aware that EF Core thinks that I am inserting a new country but that's not my intention. In the below…

asked

Raymart Atienza 1

commented

Jack J Jun 19,376 Microsoft Employee

1 answer

How to use EF Core when two properties in the Principle entity point to the same attribute in the dependent entity?

I have 2 Model classes: Department.cs cs public class Department { public string DepartmentId { get; set; } public string Name { get; set; } public string Description { get; set; } [ForeignKey("FacultyId")] public…

asked

Uchchay Dugal 21

accepted

Uchchay Dugal 21

1 answer

Inject EntityFramework DbContext in a .NET 6 Azure Function

Where do I have to put the DbContext in a .NET 6 Azure Function? builder.Services.AddDbContext<DataContext>(options => // options.UseSqlServer(context.Configuration.GetConnectionString("BlazorOrderApp"))); There is…

asked

Bernhard Sumser 101

edited a comment

Bernhard Sumser 101

1 answer

Stored Procedures returning null value in razor pages

Hi, i have two stored procedures which will execute based on the condition. First Stored Procedure : AvailableHourSlots CREATE PROCEDURE [dbo].[AvailableHourSlots] @ActivityName nvarchar(max) , @BookedDate datetime2(7) AS SELECT distinct…

asked

Blooming Developer 196

commented

Blooming Developer 196

2 answers

EF Core 6 - Truncate Table

Hi, How can I use the truncate table in EF Core 6? I tried this but didn't delete rows. _oyunPalasContext.RazerReconciliation.FromSqlRaw("TRUNCATE TABLE RazerReconciliation");

asked

Cenk 686

answered

Karen Payne MVP 29,236 Microsoft MVP

1 answer

Blazor Server - System.InvalidCastException: Unable to cast object of type 'System.Double' to type 'System.Single'.

Hi, In my Blazor server application, I am trying to get the records from RazerReconciliation table as follows. I couldn't figure out why I am getting this error. public async Task<List<RazerReconciliations>> GetOldReconsAsync() { var…

asked

Cenk 686

edited an answer

Viorel 82,911

0 answers

Bilgisayarıma .net 7.0 kurdum fakat powershell üzerinden dotnet tool install --global dotnet-ef komutu kullandığım zaman kurulu değil hatası alıyorum yardımcı olur musunuz

Visual Studio 2019 kullanıyorum ancak bu kurulumu yapamadım yardımcı olursanız sevinirim

asked

Muhammed Mustafa 0

commented

Jack J Jun 19,376 Microsoft Employee

2 answers