I have thousands of rows, but I don't want to use just Users.ToList() probably that is not efficient. I want to send just 20 or 30 row to API each request. Next 20 rows and next 20 rows I want…
I am a newbie in .Net Core, I am always using .Net Framework to develop an application (Web App / Web API). I have develop my custom Framework and it already established. my custom framework use Entity Framework 6.0 (DB…
I have two related tables like below : Users : public partial class Users { [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public Users() { } public int ID { get; set; } public int UserType_ID { get; set; } public string Email { get;…
I am using EF and in MY web config I have removed the Connection string after adding the model for the first time. So it looks like this now: <connectionStrings> </connectionStrings> I have modified my Model.context.cs file where I have…
Disclaimer:I am trying to learn more about net 6.0 and am a rookie. Here is what i am trying to do: I am trying to access IConfiguration file in a TransparencyContext but i keep on getting configuration being null error:System.ArgumentNullException:…
I have a SQL Server table that has approximately 2 million rows. Let's say the table is called Students. If I query a database from SQL Server Management Studio: SELECT * FROM Students At the same time, the currently loaded…
I have my own DbContext: public class DreamsContext : DbContext { public DbSet<UserAccount> UserAccounts { get; set; } public DbSet<DreamPublication> DreamPublications { get; set; } public DreamsContext(DbContextOptions<DreamsContext> options) : base(options) { } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<UserAccount>().ToTable("dreams_user"); modelBuilder.Entity<DreamPublication>().ToTable("dream_publications");…
I am learning C# and how to use Entity Framework. I believe that I know what is Cascade, Restrict, NoAction and SetNull behaviors. But there are other behaviors with the prefix Client: I would like to understand what are the…
I am working on a Data Entry system for storing users financial data. Each user will enter his Revenues and Expenses each in a table. The tables were designed as follows: Primary Key: Rev/Exp ID Foreign Key: Organization ID This…
I got 3 models: Human, Skill and HumanSkill. There is a many to many relationship between Human and Skill, the HumanSkill is the intermediary table between them. My query to the database loads the collection of the intermediary table HumanSkill…