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'm doing a small project using Razor pages. It's about cars. So I've created two scaffolded items from two classes: Maker and Model. This is the Maker class public class Maker { public int Id { get; set; } public…
I have the following task: - task: DotNetCoreCLI@2 inputs: command: 'build' projects: 'XXX' arguments: '-c "Release" /p:Platform="x64"' and I want to set the outputpath of the build so that I can publish an artifact after compiling. /p:OutputPath="$(build.artifactStagingDirectory)XXX" But when I…
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…
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 want to Remove/hide the 1st item from the @Html.DropDownListFor.This dropdown has four items. I want to remove/hide the 1st item only. But those values are not hard cord values, that are retrieved from the object of the model. I…