For the last three months, I worked on code creating a single searching code in vb.net but I need help to make multiple search at the time like for ex:- I search in database using vb.net is done but then I need search shart + red olor is also done, then I need search shart + red color + brand
Tag: .net
Sql server not updating records with nested case statement in a query
I’m using sql server 2012 and here is my query: it isn’t update my table just results couldn’t configure the issue even i tried a single query just like is there something which I’m doing wrong? or any other way to achieve my desired result? Answer is mandatory to write WHERE Column11 …
How to map from query string to SQL query? [closed]
So I have as search endpoint [HttpGet(“search”)] public async Task Search([FromQuery] string query) that returns a list of users from the cosmosDb based on email, name …
Polly retry policy with sql holding transaction open
I am using Polly to implement a retry policy for transient SQL errors. The issue is I need to wrap my db calls up in a transaction (because if any one fails, I want to rollback). This was easy before I implemented retry from Polly because I would just catch the exception and rollback. However, I am now using …
How to parameterize logins when executing SQL from PowerShell command
How do we run CREATE LOGIN … against a variable string? I’m executing the following command: MasterDBSetup.sql: How do we run CREATE LOGIN … against $(SvcRRRComparisonUser) ? Answer In the $SqlVariables: Then in the SQL file:
‘Procedure Has Too Many Arguments’ Error Although I Have Only Two
I checked the other posts related to this problem but could not find any answers. I have a post action method for my hotel api and in the Hotel Repository I have this CreateHotel method below. I just enter two arguments and there’s two arguments in the stored procedure too but I get this error: System.D…
Delete all related rows to user using EF .NET CORE
I have little problem with data delete. Let s assume that I have to delete user and all related rows to this user. I wrote some code in c#, but it takes ages to complete. Here is my some of my code. …
Issues with Dapper query syntax
little assistance here with my query using dapper, been getting error Message = “ORA-00936: missing expressionn” on my query. I would like to know what am I missing here? Answer Firstly with Oracle queries you need to use : instead of @ to denote a parameter placeholder. Then secondly this code: w…
Unexpected token when creating a string expression?
I have the following code: There is an error here ‘{cardId And it tells me Invalid Expression term ” Answer You need to be aware that this kind of string concatenation is avoided and it is open to SQL Injection attack, you should always use parameterized queries to avoid SQL Injection and also to …
F# Query Exception, “unrecognized method call value”
Q: What does the following exception mean? I’m attempting to translate a Pervasive SQL query to an F# query using SqlDataProvider with an ODBC connection, building up slowly bit by bit. I’m getting an exception with the following query with a somewhat cryptic exception. When the printfn statement …