All Questions
33,067
questions
0
votes
0
answers
29
views
Binding data inside a DataGrid inside a DataGrid.RowDetailsTemplate / C# WPF
I'm learning C# and WPF for a personal project that I'll use for my job.
I'm trying to create a DataGrid inside another DataGrid. Specifically, I want my first SQL query to display some data, and when ...
- 9
0
votes
2
answers
62
views
Why do I need to model a join table class?
I have two classes in C#:
public class Student
{
public string Name {get; set;}
public string Email {get; set;}
public List<Course> Courses {get; set;}
}
public class Course
{
...
- 9
0
votes
0
answers
29
views
Error "To change the IDENTITY property of a column, the column needs to be dropped and recreated."
I'm a beginner and i am having this error when i use the update-data base, after the migration:
"To change the IDENTITY property of a column, the column needs to be dropped and recreated."
...
-3
votes
1
answer
80
views
I cannot modify the table in my database with C# [closed]
I created a database and a table in Microsoft SQL Server, and I want to do some experiments with it in C#. I successfully connected to my database and I can read the first row of the table, too. But ...
- 11
3
votes
1
answer
88
views
Join tables with condition that all row values are unique
I have tables Machine and Inventory. In table Machine I have last running inventory properties. In table Inventory, I have new inventory id and properties (Not yet run in machine).
I have to return a ...
- 35
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
1
answer
69
views
String interpolation inside a formattable string in C#
I am in the process of replacing Dapper with EF Core in a project. Specifically using the new Database.SqlQuery and Database.ExecuteSql functionality with EF Core. I like how they use ...
- 151
0
votes
0
answers
33
views
How to map value objects in dapper
i have the following entity
using MedRaise.Domain.Enums;
namespace MedRaise.Domain.Entities;
public class Appointment : Entity
{
private Guid _clinicId;
private DateTime _date;
private ...
2
votes
0
answers
59
views
How to convert this SQL query to NHibernate IQueryable query?
I have to create a query similar to the one below to paginate a parent-child query:
SELECT v.ProductId, MAX(v.Price) AS Price
FROM Variant v
GROUP BY v.ProductId
ORDER BY Price ASC;
I am using C# ...
1
vote
2
answers
120
views
Multiple tables query with repository pattern
I have an ASP.NET Web API project, and have implemented repository and unitOfWork patterns.
I currently have a big SQL query that I want to implement in code, it includes a lot of tables and joins.
My ...
- 337
0
votes
0
answers
44
views
How to pass a specific parameter to my dataset
I have DataTable as a result of executing a stored procedure. The stored procedure is returning a number of tables, therefore Tables[0], Tables[1], etc.
I'm trying to query the first table, Tables[0], ...
- 649
1
vote
1
answer
56
views
Join tables based on StartsWith function
I have two tables to join. The joining condition is a column that should be like or starts with the other column, not exactly equal. How to do that in Linq? This is my function:
public async Task<...
- 135
1
vote
1
answer
96
views
How to properly manage and dispose SqlConnection with SqlCredential in EF Core using Dependency Injection?
I am working on an ASP.NET Core project where I am using SqlCredential for database authentication, provided by a SqlCredentialProvider which is designed as a singleton to ensure a single instance ...
- 26
0
votes
0
answers
25
views
Nhibernate get max items
I have a plan table which is having the following structure
id plan_id plan_number
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
for each plan I would like ...
- 11
0
votes
2
answers
95
views
Convert a string to base 64 using T-SQL
I'm having the issue while converting the string to base 64 for encoding using T-SQL. As I use chatgpt to search and some function like
SELECT BASE64_ENCODE (CAST ('hello world' AS varbinary))
SELECT ...
