In an asp.net mvc application, I am trying to perform a selection based on what user selects from product specifications. Imagine a user selected these parameters as a selection: manufacturer: [apple, sony, samsung] ram: [8, 128, 256] size: [12, 13.5]…
I am trying to merge two lists into one List without duplicates JOIN operator returns only common elements These are lists in JSON List1 is: { "screenID": 96, "create": true, "read": true, "update": true, "delete": true, "print": true }, {…
I have a database table AdvisorComments where I have advisorID and studentID along with other columns. There can be multiple records for same advisorID and studentID. Also, an advisorID can have different studentIds and vice versa. I have another table…
I need to group it based on month and get the Max and Min counts. Hear, Sep Month has Max count and Jun Month has Min count. So I need max value as 5 and Min value as 1. Thanks…
Trying to generate items for a database using Bogus using this code: var products = new Faker<Product>() .StrictMode(true) .RuleFor(e => e.Id, f => 0) .RuleFor(e => e.Name, (f, u) => f.Commerce.Product()) .RuleFor(e => e.Price, (f, u) => Convert.ToDecimal(f.Commerce.Price())) .RuleFor(e =>…
That code makes filter on the files with the regular expression, and to shape the results. But how can I get a line number of each matches in the file? I have no idea how to do it... Please help…
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 working on a query where I want to retrieve data including multiple int? keys. My output Dto: public class FilterParamsDto { public int? StudentId { get; set; } public int? NationalityId { get; set; } public int? CountryId…
I have come across a situation where I need to show the previous and next record of a matching record , suppose I have a data source for products and the products are sorted by name . Now after retrieving…
I am learning Dotnet c# on my own. how to find whether a given text exists or not in a string and if exists, how to find count of times the word has got repeated in that string. even if…