I am trying to connect my Web API build in asp.net 6 with MySql and I am having a lot of trouble My Service looks like this builder.Services.AddDbContext<TicketApiContext>(options => options.UseMySQL("CONNECTION_STRING")); and my Database Context like this. using Microsoft.EntityFrameworkCore; namespace VelocityNetAPI.Data…
I am writing a Unit test where in i am passing array of two records and i want to send it to a method which can filter the records and pass only a single record but i have tried to…
In my application I have a drop-down menu that lists various customers, and a second drop-down that will list the cities with which a given customer is associated. Selecting a customer should populate the second drop-down with the relevant list…
I am unable to publish my web application. It never completes and also never gives any errors. Rebuild solution works without any issues, it is just when I try to publish to a folder that it does not work. Web…
I am trying to make APIs using ASP.Net Minimal API thingy and I am trying to use PostgreSQL as Database so for that I am following an Article and and I have followed it so far but I am unable…
I want to create an extension method for WebApplicationBuilder: public static void AddData(this WebApplicationBuilder builder) { var connectionString = builder.Configuration.GetConnectionString("DefaultConnection"); builder.Services.AddDbContext<ApplicationDbContext>(option => { option.UseSqlite(connectionString); }); } this method works in a project that use: <Project Sdk="Microsoft.NET.Sdk.Web">, but if I put…
I'm using EF 6 in my project. All i want is to fetch some data from the database and sometimes join additional data. Here is my code: var queryable = dbContext.Manuals .AsNoTracking() .Where(x => x.Status == "ACTIVE"); if (showDisabledParents) {…
I'm a newbie working with ajax. I have a problem while sending the data into ajax post. The output of console.log(obj.Id) and console.log(oke) is 2. Then I tried to send it through data in ajax, but it end up 0…
I am capturing a URI in ASP.NET MVC with webcam.js. I would like to turn this URI to to bitmap in C#. Below is my current code for attempting to parse the URI into a bitmap, but it, but it…
I have LINQ expression to take top 15 most frequently used answers Here is expression var latestAnswers = await _dbContext.TextAnswers.Include(x => x.CompanySurvey).ThenInclude(x => x.Survey) .Where(x => x.CompanySurvey.Survey.FiscalYear == 2022) .GroupBy(x => x.Answer) .OrderByDescending(g => g.Count()) .Take(15) .ToListAsync(); But I get…