I am trying to query a view, which has an "Operator" column. Sample data: Ed Edward Ed;Adam [null] Bob; Edward Bob; Ed; Tom Given a user input of a List<string>, let's say "Ed","Peter", "Mark", I want to return rows that…
I want to select the multiple column based on if condition, While adding "Select" method as nested it is not working, Getting null for each properties in the class. So how to fix this? public async Task<Form?> GetFormByIdAsync(long formId, string…
So I'm transferring domain classes (a lot) to the postgres with EF6. Classes can have value type properties, like int and float, and are being transferred to postgres as NOT NULL. I can't make my domain classes properties nullable, as…
I have a list of objects and I want to filter the list by removing some objects that have ids present in a separate list i.e. List<Vehicle> vehicles; //All Vehicles List (260 vehicles data) List<int> vehiclesIds; //Ids List to remove…
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 am learning C# and how to use Entity Framework. I believe that I know what is Cascade, Restrict, NoAction and SetNull behaviors. But there are other behaviors with the prefix Client: I would like to understand what are the…
I develop one web form by using ASP.net, I want to select the row and display that row data into web form but the date cannot display in the textbox of type DateTime, someone helps me to sort out this…
When I select dropdownlist I want to retrieve data from database according to dropdownlist ID. The whole row is retrieved through an ajax call and I only want PurchasePrice and RemainingQuantity to display through label in view. Second is: I…