Entity Framework Core Tool doesn't work from dotnet tool
Hello ! I've encoutered an issue using EntityFrameworkCoreTool 5.0.4 : When I install the nuget package and run a scafold command from the package manager console, it works fine. But when I install it as a dotnet tool using dotnet tool install dotnet-ef…
About.core3.1 Dynamic Compiling
Hi, I was compiling some code dynamically with Core3.1 and was told that the platform didn't support it, but using the Framework was fine.I don't know how to return a responsibility, ask everybody to help using RRQMSocket; using RRQMSocket.RPC; …
Ef Core - weird behavior of AddRange
Here's my code: [Table("prom_term", Schema = "demo")] public class PromTerm { [Key] [Column("promotion_terminal_id")] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int…
Why .NET Security Updates for x64 Windows Server includes many other packages including ones for Desktop systems and x86 systems
Hello, I'm curious how one is suppose to determine which of these packages in the update shown below is supposed to be installed when downloading from the MS Update Catalog? If you are running a Server OS (say 2016 Datacenter x64) and that server has…
SQL Server and EF Core, create “Lock Request Timeout” error
(I asked this on StackOverflow as well, figured I'd throw it out here too) I recently had my EF Core (2.1) code throw a DbUpdateException, caused by a lock request timeout. I think I understand the basic idea behind this (EF doesn't lock items until it…
EF Core add new record, assigned identity when life cycle is scoped
Hi In asp.net core 3.0 app with ef core 3.18, dbcontext registered AsScoped, when a new record created with identity set as integer and incremental, and automatic number identity value is assigned to that entity record, say 1, if at the same time in…
Eager loading by default in the model
Would like a specific entity to have a navigation property eager loaded by default. Is this a feature in EF5? https://github.com/dotnet/efcore/pull/19355
Not all FK's updating con savechanges
Afternoon, Hope someone can help me, I have the following model: The rough code (I know its a mess) at present while I am trying to workout what is going on is as follows to add a note and link it to the changelog: public async…
The Name of the Tool from the Picture
Goal: The name of the tool in order review the code as a sql code when you apply the input linq code C# (https://www.red-gate.com/simple-talk/wp-content/uploads/imported/2325-1-2fbc0f9f-774f-441e-a91c-acdd4a812ba7.png) Problem: What is the name…
Entity Framework Core 5 doesnt support Oracle 10G?
I'm trying to create a Model from my database Oracle(10g) using Scaffold-DbContext. Scaffold-DbContext "DATA SOURCE=XPERTISE.world;PASSWORD=XXX;USER ID=SCHEDULE" Oracle.EntityFrameworkCore -OutputDir Models -Tables MEETINGS -Force. Im…
EntityFramework Any in Where
Hello, when i try to use Any in EF Core where, i get an error. can you help? query: var identifierslist = new List<DeviceIdentifierModel>(){..identifiers here...}; var devices = await _context.Device.AsNoTracking() …
Update entities all at once
I have a list of entities returned me from external service, in this list i would take only item with flag IsNew setted to true and save in my database. My code is: var entitiesLst =ExternalService("BoxIt"); foreach (var…
Very slow database creation within Azure function project deployed to Premium plan
Something I have discovered whilst investigating some performance issues is that it is taking entity framework between 6 and 7 seconds to perform the first database operation (the database has 152 tables) when deployed into an Azure Premium Function…
set variable of partial class
I have a generated clas (with soapui) I need to pas data to a class order This class has partial classes The code : This is what i try and th error i get .... Dim orders(1) As dpd_label.order orders(1) =…
Passing multiple Lists in single parameter
Hi Team I have below requirement. ' There are 3 list with different class type. Example: List<Customer> lst1=new LIst<Customer>(); List<CustomerOrder> lst2=new List<CustomerOredr>(); List<CustomerTransaction>…
Sample code Asp.Net Core Datatables Jquery pagination MVVM Services
Hi, I would like a template sample code to get started, with Asp.Net Core CRUD operations with search pagination , master detail pages. Dependency Injection CODE FIRST ENTITY Framework Datatables Jquery I have a solution developed on…
EF Core 5 many-to-many disconected add/remove without join entity class
EF Core 5 introduced many-to-many by convention, we only need to add the collection navigation property on each side and it works. I know I can query one side of the relationship, add it to the collection property and save it, but this requires an…
Receiving chat messages with SignalR
I tested the SignalR solution in Xamarin Forms and .net core backend and it works great: https://montemagno.com/real-time-communication-for-mobile-with-signalr/ However, I am wondering how to keep receiving the messages when the app is in background…
EF Core question regarding relations
I'm building a ticket system. I have two models: User and Ticket. A user can have multiple tickets, and is bound to the ticket via the Customer_Id field. Another user, with the role of Practitioner, can also be assigned to the ticket, via the…
Where to store xamarin forms chat messages
Hi, I need to implement a chat service in my app. Before I get too far on this, I would like to ask for an opinion on where to store chat messages. My options so far are: Twilio chat My own DB There are pros and cons, Twilio chat costs…