entity framework

Hello friends, I am working on a Blazor Server application. I would like to upload an excel file, consisting of a couple of columns. (ReferenceId-guid, Order Date-datetime, Product Code-string, and Product Description-string) This excel file roughly has 200000 rows of data. I am gonna use...

Hello friends, I am working on a Blazor Server application which is running on production for a while. There is an Orders table, user can insert records. Here is the table structure; USE [InventoryManagement] GO /****** Object: Table [dbo].[Orders] Script Date...

I work on .net core 6 vs 2022 i see function have telement but i don't know what this mean can you show me please ? and when use it are there are any thing best from using telement or more general What I have tried: public List<TElement> SQLQuery<TElement>(string sql, string...

I work on Web API c# web app . I face issue I can't login success although I have same username and password . when make break point on websecurity.login then trace it jump to ModelState.AddModelError so are there are any settings remaining or some configuration not done . public JsonResult...

Hello, I'm doing a windows form project, in this project, when I subtract the entry date from the end date, I reflect the result to a column named remaining usage. What I want in the database is that this remaining usage decreases by 1 every 24 hours

I would like to develop a digital display menu system which doesn't include any ordering feature. Currently I get stuck in handling entity relationship between menu list and menu item. Should I use a mapping table for them? or I can simply handle menu items inside menu list instead of creating...

See code below: public ActionResult<List<string>> FetchConfig([FromBody] FetchConfigDto fetchConfigDto) { List<string> myResult = new List<string>(); _logger.Debug("getting config from database"); try {...

Hi everyone, Is it possible to do scaffolding after install our program and run it? Is using powershell right way to go to do this? Or what else can I do? I need any advice of you. Thank you.

Hi, I need to do scaffolding in code. To do this I wrote this method; public string RunScript(string scriptText) { string dir = @"C:\Users\demetsen\source\repos\ScaffoldingInCode\ScaffoldingInCode"; Directory.SetCurrentDirectory(dir); Runspace...

Hi, I wonder if it is a good practice to add this line of code to production? error: System.InvalidOperationException HResult=0x80131509 Message=The model backing the 'GameContext' context has changed since the database was created. Consider using Code First Migrations to update the...

Hi Team I need some help in joining three entities using linq, i have one join but the problem i have i am getting a repetion of years, weekNum and day colums with data being incorrect. public IList<ExtractionViewModel> GetExtractionViewModels(string year, int week) {...

I'm building a very simple CRUD web-application (ASP.NET MVC) for tennisplayers and the tournaments they can participate. On a specific page I want to show all tournaments in the database with a title at the top op the page 'All Tournaments' with between brackets the amount of records in the...

Hi, I have an issue with validation messages. I think the problem is caused by 2 post method. [HttpGet] [Authorize] public ActionResult Others(string bid) { return View(ret); } [HttpPost] public ActionResult...

Hi everyone, I'm making a very simple CRUD console application using EF and sqlite. I have 3 domain model classes, being: Player, Tournament and TournamentEnrollment public class Player { [Key] public int Id { get; set; } [Required] public string...

I'm following a EF Core (beginners) course and there is something I don't understand. Below you can find the most important classes of a little excercise we got, to get to know EF core and the intent. public class Student { public int StudentId { get; set; } public string...

i have a problem with Entity. Want to use Entity in DbContext class but it is not working even though I added it to the packages. So when i write the "System.Data.Entity", it turns red. (Error: CS0234) Maybe Visual Studio doesn't see the Entity package. Visual Studio 2019 .NET Core 2.0...

Hello All, I have one query which I wrote in SQL but now i want to convert it to EF and I am finding difficulty on understanding how do I incorporate multiple select statements in EF SQL Query: SELECT TOP {count} * FROM ( SELECT co.orderid,co.orderStatusId...

I've been trying to launch a .NET Framework web application to Azure, and I can't seem to get it. Every tutorial out there is using, or pushing .NET Core. This is a basic application using C#, .NET Framework 4.7.2 MVC, and connecting to some REST APIs. 1. When deploying .NET Framework app, do...

Is not more nedded. I try delete the post, but no find this option

I am pretty much new in C# programming and desktop applications development. Still, I have a deep understanding of OOP concepts, patterns etc., because I come from other languages/platforms. What I am interested in, are some guidelines / best practices... I am about to to make an app that will...