All Questions
2,921 questions
0
votes
0
answers
94
views
Microsoft.Data.SqlClient.SqlError: Incorrect syntax near the keyword 'AND'
This is the error I'm getting when I trye to execute the code.(https://i.sstatic.net/Z2MVQ0mS.png)
Error message: Incorrect syntax near the keyword 'AND'.
StackTrace:
at Microsoft.Data.SqlClient....
0
votes
1
answer
86
views
Can SQL query affect my blazor app rendering perfomance?
OVERVIEW
I know this question is obvious but let me give some overview. So I wanted to delete data from multiple tables in my SQL Server database since some of those tables have FKs, constraints, etc.....
- 47
-2
votes
1
answer
113
views
How to use query with quotes inside a parent query [closed]
I have a use case, where I need to update column value which is itself a query.
Table structure:
CREATE TABLE MyTable
(
ID int,
Query varchar(max)
)
Update query:
UPDATE MyTable
SET Query =...
- 66
0
votes
1
answer
43
views
How to distinguish when FOUND is false from when row version is obsolete in a Postgres stored function
Working on implementing optimistic concurrency in a .NET application backed by Postgres, I have arrived at an impasse.
The following stored function returns FOUND, enabling the invoking endpoint to ...
- 3
0
votes
2
answers
65
views
Loading information from a SQL DB to an array of buttons, they are not in order [closed]
I am writing a point-of-sale (POS) app where I have the layout number (1-35), text (price and product name) and image of the buttons in a SQL database. There is a ItemLayout table in the database, ...
0
votes
2
answers
134
views
When updating many rows in a column of a SQL table, how can I skip rows which are locked, or that are taking too long to update [duplicate]
The application is coded in .NET using ASP.NET webforms. I am trying to change the Priority code of several hundred order numbers.
The new code to be assigned is what the user selects in the Drop down ...
- 27
-1
votes
1
answer
71
views
How to store data in SQL server in different languages for language translation in a lengthy table?
I am working on a C# .NET application that needs to support the translated state names, districts, sub-districts, and villages into over 20 languages. Given that there are over 100,000 records for ...
- 21
0
votes
1
answer
169
views
Unable to Save Image Data to SQLite Database in MAUI Application
Problem Overview
What you are trying to do:
I am trying to save image binary data into a SQLite database named gazouByte.db3 when the "Save" button is pressed after selecting an image file ...
- 1
0
votes
0
answers
28
views
Use some kind of helper function In EF Select query to make subquery [duplicate]
I have several tables that handles different kinds of translations for my entities and those tables to linked via relations to other entities.
I use subquery to directly access translations tables ...
0
votes
0
answers
56
views
Trouble Determining Dependent Side in One-to-One Relationship with Entity Framework Core
I'm currently working on a project using Entity Framework Core in a .NET Core application. I'm having trouble determining the dependent side in a one-to-one relationship between the User and Account ...
0
votes
2
answers
73
views
How do I do an inner GroupJoin on dotnet?
I'm using .NET 6 with Entity Framework. This is my situation:
I have a BenefitEntity (with Name and Description properties and a relationship with BenefitCategory) and this BenefitCategory which has ...
- 71
1
vote
1
answer
59
views
Group by, count distinct SQL query to IQueryable using Linq
I am trying to translate the following SQL into IQueryable, so I can access the result and filter on different conditions, before the data is retrieved from the database,
but I get an error that the ...
- 123
0
votes
2
answers
54
views
Oracle parameterized query for explain plan in C#
I have an explain plan query and I need to call with parameters in my .Net application. When I try it as following it gives me ORA-1780 Error. I have many parameterized queries in my application but ...
- 81
0
votes
1
answer
78
views
Is there a way to enforce a specific JSON structure for JSON column?
I have a column in my table that will hold JSON objects. I currently have the column defined as MY_JSON_COLUMN NVARCHAR(MAX)
Is there a way to make sure the JSON adheres to a specific structure?
For ...
- 1,207
0
votes
2
answers
47
views
sql difficulties counting one column and getting the oldest id with the same content
I'm making a school project in mvc .net core, where people should be able to send in a request for help and it will show on a screen, my difficulties comes with the part that other people should be ...
- 9