All Questions
Tagged with .net sql-server
6,500
questions
-2
votes
1
answer
14
views
i have this error The page cannot be displayed because an internal server error has occurred [closed]
When I uploaded the site to the host, there was no problem. But when we are working with the site. For example, we return to the main page or perform a delete operation, this error occurs!
I ...
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 ...
2
votes
1
answer
129
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 ...
-2
votes
0
answers
27
views
Dynamic Database Driven External API Call Service: Seeking direction/concepts to focus research on [closed]
Dynamic Database Driven External API Call Service: Seeking direction/terms to focus research on.
Thank you in advance for any responses i get. I'm here seeking a direction for research and any related ...
2
votes
1
answer
72
views
.NET SQL Deadlocks (randomly) not picked up by SqlCommand
I'm really struggling with something, and I was hoping that I could get some advice or if someone could point me in the right direction with this.
I have a program that processes entries concurrently ...
-1
votes
1
answer
57
views
.NET 8 API with SQL Server: Error During Login Process
I am using .NET 8 to create an API that connects to a SQL Server. My connection string is as follows:
configuration["ConnectionStrings:DBConnection"] = "Data Source=\"MYIP, MYPORT\\...
0
votes
0
answers
26
views
Network error while updating database in Visual Studio nuget package manager
I was watching a tutorial on Blazor Wasm with cookie authentication and I'm getting this error after I ran update-database in the console.
A network-related or instance-specific error occurred while ...
0
votes
1
answer
48
views
SQL Server XML column is string in .NET using SqlDataReader
Why if in SQL Server, I have a column defined as XML type, and in .NET with SqlDataReader/SqlDataAdapter I have a string?
See the example in the screenhsot, cast c1 in XML, but .NET gets a string.
I ...
0
votes
0
answers
71
views
Entity Framework Core Unidirectional many-to-many not working
I want to use a Unidirectional many-to-many relationship but I can't seem to get it to work.
I use EF Core 8.0.6 and recreated the example (https://learn.microsoft.com/en-us/ef/core/modeling/...
0
votes
1
answer
67
views
Better way of handling many-to-many relations with EF db-first approach in .NET6
I'm having a Request table (EF generated):
public class Request
{
public int Id { get; set; }
public string Name {get; set; }
public virtual ICollection<AttendeeRequest> ...
2
votes
2
answers
190
views
What's the best way to update ~500 entities with EF Core? [closed]
Right now I loop through each entity and call ExecuteUpdateAsync then after the loop I call CommitAsync, but I'd like to know if there is a better way for updating ~500 records?
I see this bulk ...
0
votes
1
answer
47
views
System.Data.SqlClient.SqlException but table is exists in the database [duplicate]
I use Quartz to perform background tasks in my .NET core project. Here is the code for my Quartz:
public class ReportsChangesJob : IJob
{
private readonly IReportsService _reportsService;
...
0
votes
1
answer
27
views
Bulk copy do not execute when called SSIS package called from Autosys
I have Ssis package deployed on integration service catalog.
It execute perfectly when I right click and execute the package on SSIS db.
However when the package is triggered from autosys it does all ...
-1
votes
1
answer
108
views
Unhandled exception. Microsoft.Data.SqlClient.SqlException (0x80131904) [duplicate]
I cannot connect to the database and do migration even though my connection string works fine when I connect SQL Server Management Studio through Docker file, I wonder what am I doing wrong.
my ...