entity framework

  1. R

    Question How would you compare an excel with data in the database table?

    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...
  2. R

    EF Core 6 - Primary key incrementing problem

    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...
  3. A

    Question What telement mean here and when it use it?

    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...
  4. A

    when make login using simple membership it not logged in success although I use same user name and password?

    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...
  5. uzeren

    C# timer

    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
  6. S

    Resolved Digital Menu Display System Database Design (EntityFramework Core)

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

    Hi can anyone tell me why I'm getting a empty list back when executing this entity framework query?

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

    Scaffolding after install the program

    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.
  9. D

    Run Scaffolding Command in C# Code with Powershell Runspace

    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...
  10. R

    Adding a new property to an existing model

    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...
  11. Gcobani54

    Joining three entities using linq

    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) {...
  12. M

    Question Same query fired multiple times EF

    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...
  13. etkmlm

    Question Validation Messages Not Working

    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...
  14. M

    EF returning old data

    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...
  15. M

    Beginners question regarding AsEnumerable()

    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...
  16. etkmlm

    Resolved Entity Framwork Not Working

    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...
  17. P

    How do I convert my SQL query to Entity Framework DBContext

    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...
  18. M

    Answered Publish .NET Framework on Azure Still Possible?

    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...
  19. A

    Question The item with identity [x] already exists in the metadata collection

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

    Windows Forms application with a shared database

    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...
Top Bottom