I wish to run a raw SQL Delete Query on EF Core and I am suing the following guide to help me along: https://learn.microsoft.com/en-us/ef/ef6/querying/raw-sql The code: using (accountingContext db = new()) { db.Database.ExecuteSqlCommand("DELETE FROM ..."); } but I get the…
I have query in linq and I want to convert that query in sql I am not very good in linq so can anyone help me to convert this query in sql: We have ticket table and issues table ticket…
I am using MVVM here. I have one model Patient.cs and 3 view models ViewModel1, ViewModel2, ViewModel3. I now have to convert 3 view models into one model. Can someone please let me know the best way to do it.…
I am new to.NET Visual Studio and building an ASP.NET MVC Application. This is my code and I am getting error on the Add Part namespace proj.Controllers { public class EmployeeController : Controller { // GET: Employee emp_RegEntities dbObj =…
When my server application starts it reads about 20 records from my database (using Entity Framework with Npgsl to read from a PostgreSQL database). There are a couple bytea columns, one of them is pretty big. On average it holds…
I am confused to understand the difference between Linq's Count() for IQueryable and Linq's Count() for IEnumerable. I have the following method which has to return the same result of the counts, but enumerableCount equals 2 while queryableCount is 0:…
I'm doing pagination with EF core 6 and dotnet core. public async Task<IEnumerable<CommentResponse>> GetCommentOfPostAsync(Guid PostId, int PageNumber, int PageSize) => await _context.Comments .Include(comment => comment.User) .OrderBy(comment => comment.CommentId) .Select( data => new CommentResponse { CommentId = data.CommentId, UserId = data.UserId,…
var json = JsonConvert.SerializeObject(data); var stringContent = new StringContent(json, Encoding.UTF8, "application/json"); var httpContent = new MultipartFormDataContent(); httpContent.Add(stringContent, "params"); using var httpClientHandler = new HttpClientHandler(); httpClientHandler.ServerCertificateCustomValidationCallback = HttpClientHandler.DangerousAcceptAnyServerCertificateValidator; var httpClient = new HttpClient(httpClientHandler); var response = await httpClient.PostAsync(url, httpContent); response.EnsureSuccessStatusCode(); if…
How can I create a relationship in EF core where the child(FullName) table has DrugId which is the primary key. In the parent table(Basic Data), DrugId is foreign key. But there are other child tables and they are also referring…
I am trying to optimize this query using EF. This is the query that I had at the beginning. var result = new List<string>(); _dbContext.signumid_organization.ToListAsync().Result.ForEach(organization => { if (CalculateDifferenceBetweenEntriesAndConsummations(null, organization.Id).Result > threshold) { return; } if (!string.IsNullOrEmpty(organization.Admin)) { result.Add(organization.Admin); }…