All Questions
4,980
questions
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
42
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
66
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 ...
- 61
1
vote
1
answer
53
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 ...
- 93
0
votes
2
answers
46
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
66
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,151
0
votes
2
answers
46
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
-2
votes
1
answer
42
views
vb.net display current week database records
I found some other reference here in internet and tried this code so far, but seems not to work. Can someone help rearrange or modify my code for displaying record current week.
Sub loadCheck()
da ...
- 27
0
votes
0
answers
133
views
using ajax with asp.net core mvc .NET 8 in visual studio 2022
I have a view that shows information from a sql tabel that I inserted in to a local DataTable I want to create a button that filters what is shown with ajax
this is the loop where the information from ...
- 1
-1
votes
1
answer
107
views
How to correctly pass nvarchar parameter to SQL Stored Procedure from .NET Application?
I would like to execute a SQL stored procedure (SP) with parameters. However, I am having difficulties passing nvarchar (string) parameter called "office" to the SP.
If I want to execute the ...
- 348
0
votes
0
answers
59
views
Convert C# DateTime.Ticks to Bigquery DateTime Format
I have a column in my Bigquery table that is filled by C# Ticks:
DateUtc = DateTime.UtcNow.Ticks;
This is something like: 638148714773184690
I want to convert it to Bigquery DateTime.
- 21
0
votes
0
answers
38
views
OracleCommand parameters not being converted in C# [duplicate]
I'm trying to setup an OracleConnection in .net which has been successfully working until I tried to add parameters via the OracleCommand. I get the error 'ORA-00903: invalid table name' which is ...
0
votes
1
answer
96
views
Using System Managed Identity from Web App to connect to two different DB? Login failed for user '<token-identified principal>'
I have a .Net App hosted in Azure with System Managed Identity enabled (samplewebapp) and also I have two different DB which the application needs to connect. We have enabled Managed Identity in both ...
- 167
0
votes
1
answer
32
views
SQL to Linq conversion with SYSDATETIMEOFFSET
Could someone assist me in converting following sql query to LINQ? Important part of this one is to be able to convert the date to a UTC date (with daylight savings).
SELECT a.id, b.id
FROM ...
- 400
0
votes
0
answers
43
views
Issue while saving using Entity Framework Core with datetime columns constraint
(this is another side, something similar but the others are difference to this question which was answered Issue while saving using Entity Framework Core with constraint)
I have a table UserSession ...
- 181