I have a table "StaffMembers" that have columns indicating the number of days worked in a month, the properties in the model are as follows: public class StaffMember { public int Id { get; set; } public string Name {…
This is my controller code : [HttpPost] public async Task<JsonResult> GetWebsite(int Id) { var website = await _uWebsitesService.GetWebsite(Id); return (website == null ? this.Json("Website Not Found") : this.Json(website)); } And this is my ajax : $(".edit-website-btn").on("click", function () { let…
i am trying to run a .Net6 Entity Framework API on my raspberrypi. After following the Microsoft Docs and running the application, i cannot access swaggerui or API. There are no errors poping up in console when i try to…
I have an .Net5 solution using Entity Framework 5.0.0. Im able to save data to the Backend SQL DB and all is well. But when I try to check is a record exist using the statement below im getting an…
I have the following Category Model: public class CategoryDTO { public int Id { get; set; } public string Name { get; set; } public List<SelectList> WarehouseNames { get; set; } } Warehouse Model: public class Warehouse { public int…
I have a list of objects and I want to filter the list by removing some objects that have ids present in a separate list i.e. List<Vehicle> vehicles; //All Vehicles List (260 vehicles data) List<int> vehiclesIds; //Ids List to remove…
Using asp net mvc what's the best practice for creating an action that allows to create a new project whose owner is the current logged user? // Entities class User { [Key] public int Id { get; set; } public…
I have the following background service running: protected override async Task ExecuteAsync(CancellationToken stoppingToken) { await Task.Run(async () => { while (!stoppingToken.IsCancellationRequested) { using (var scope = _scopeFactory.CreateScope()) { DataContext dbContext = scope.ServiceProvider.GetRequiredService<DataContext>(); var tasks = new List<Task>(); tasks.Add(siteA.ProcessSchedule(SportLeagues.MLB, logger, dbContext));…
I have an entity table with below model public class VulnerabilityImportFileLog { public Collection<Vulnerability> Vulnerability { get; set; } } Trying to return an string value using the select statement in the entity framework query var vulnerabilityImportFileLogSelect = vulnerabilityImportFileLogQuery .Select(vulnerabilityImportFileLog…
I'm trying to create a web application / api using the dot net core. for the database I choose Microsoft SqlServer, and EntityFrameworkCore as ORM in previous versions like Asp.Net MVC 5 i used like this: Install-Package EntityFramework and i…