All Questions
Tagged with c# sql-server
36,802
questions
0
votes
0
answers
24
views
Issue with Building .sqlproj Project on macOS Due to Missing SSDT References
I'm currently working on a .NET 6 project. It includes a .sqlproj file for database schema management.
Problem faced
When trying to build the project with the .sqlproj file on macOS, I get build ...
-1
votes
1
answer
33
views
Getting a timeout only in GitHub Actions when trying to use SQL Server with TestContainers
This is my first time trying to use TestContainer. I am using it to make sure the tests run on a fresh database. This works with Docker Desktop locally and runs quite fast. I am now testing to see how ...
- 1,178
2
votes
1
answer
131
views
Why is C# DateTime.Now/DateTime.UtcNow ahead of SQL Server's SYSUTCDATETIME()/SYSDATETIME() even though C# code executes before the SQL Query
I want to know the reason why my C# date is larger than the SQL date even though the C# code is running first and after that the SQL query,
Logically the SQL date should be greater than C# date.
For ...
- 29
-2
votes
0
answers
46
views
Select rows from database using dapper dynamic and reconstruct into custom object list in C# [closed]
I am fetching data from the database using Dapper as a dynamic list.
ID
ATTR
ATTR_VALUE
1
A
CAR
1
B
BUS
1
C
TRUCK
2
A
CAR
2
B
BUS
2
C
TRUCK
I have tried mapping the above dynamic data to the ...
0
votes
1
answer
52
views
How can I synchronize an online SQL Server database with another offline database in Winforms on .NET Core?
I need to sync a large local SQL Server database to a server database and vice versa. The structure of these two databases is exactly the same. We need to sync data when the user is logged in, or when ...
2
votes
0
answers
47
views
Join tables with Entity Framework Core ignores join filter
Recently, I upgraded my project to use Entity Framework Core instead of Entity Framework. I have a query in my project that has recently started timing out.
When I checked the profiler, I noticed that ...
- 21
-2
votes
0
answers
49
views
Improving performance of contains method in ASP.NET MVC web application with large dataset
I have an ASP.NET MVC web application using C#, Visual Studio, and SQL Server. This is my code:
if (!string.IsNullOrEmpty(Name))
{
query = query.Where(x => x.PatientName.Contains(Name));
}
The ...
- 166
1
vote
2
answers
90
views
Transform DateTime field to provided format in where clause
I'm trying to integrate a search function in my datatable in Asp.Net Core. I load the content dynamically with a query to my MSSQL server. As the database table content will increase drastically over ...
- 19
-1
votes
0
answers
41
views
C# caused a format change of the German alphabet in SSIS package
In SSIS, i have a "Data Flow", which contains "OLE DB Source" and Flat File Destination (CSV).
The Original CSV is also UTF-8:
The Flat file is UTF8:
When I Run it, data ...
- 85
-1
votes
0
answers
53
views
SQL Server best export import option of selected range of records [closed]
Via SQL Server Management Studio (or via a SQL query), we can export one or more tables (data or structure or both of them) with related tables, and we can import them via the same methods as shown in ...
- 2,435
0
votes
0
answers
72
views
How do I set SQL Provider in C# Linq
I changed the default collation of my SQL Server 2022 database (and all string objects that already existed) to Latin1_General_100_CI_AS_SC_UTF8.
Unfortunately, LINQ to SQL seems unable to handle this ...
- 1
0
votes
1
answer
61
views
Many-to-many relationship update in EF Core
In my two classes I created a many-to-many relationship:
public class Author
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
[DisplayName(&...
-1
votes
1
answer
37
views
SSIS Script Component Used as Source Does not Write Rows to SQL Destination
I'm using SSIS in Visual Studio 2019 to read fixed width text files. Depending on the first character of each row in the fixed width file, I'm sending the line to one of two specified outputs. Both ...
- 3,171
0
votes
0
answers
22
views
Crystal Report is loading but not displaying any data
I implemented code to load the Crystal Report using a Web API call in my Windows Forms application.
Below is my report load event. fromDate, toDate, profileId are the user input parameters to execute ...
0
votes
0
answers
63
views
Stored procedure not running after 10 minutes
I am working with C# and SQL Server.
I am calling a long-running stored procedure in SQL Server from C# using the System.Data.SqlClient.SqlCommand class.
The SQL Server's remote query timeout (server ...
- 1,661