I am coming from Laravel and new to ASP.net MVC. In Laravel I used to do this to assert if a record was created in database or not: public function test_a_user_is_created_in_database() { // Arrange // Act $this->assertDatabaseHas('users', [ 'email' =>…
i am working on a ticket where there is a array of data i am passing as parameter to a method and based on the parameter and another date parameter i want filtered result but i am not able to…
I am connected to my SQL Server database and this is my code : public string Get() { string Sql3 = "(SELECT TOP 10 Raspberry_ID, Raspberry_name, Speaker_Name, currently_playing_song, Speaker_Volume, Speaker_Availability, Speaker_Mute, Date_Time, Speaker_Status, ROW_NUMBER() OVER (ORDER BY Date_Time DESC) AS…
I have a strange problem: a model that has a SelectList, but in POST action, ModelState.IsValid is false because of that SelectList: public class CarMakesViewModel { public Guid Id { get; set; } public Microsoft.AspNetCore.Mvc.Rendering.SelectList Nationalities { get; set; }…
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…