10,114
questions
-4
votes
0
answers
34
views
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server, when saving in database [duplicate]
Im creating a system where i need to save the data from textbox where i need to save it in my database.
after entering corresponding data i and click the button where i input my sql command query. It ...
0
votes
1
answer
26
views
How to create two details section with headers separated under group header section?
I work on crystal report I face issue how to display two details section with different headers related to same group by licenserecid ?
I can display first section related to group licenserecid ...
0
votes
0
answers
19
views
Loading Data with Entity Framework: Data Loss in List
public async Task<ApiResponse> GetAllGroupsAsync(Guid studentId)
{
var groups = await _dbContext.ProjectGroups
.Include(x => x.StudentGroups)...
0
votes
1
answer
58
views
C# EF Core connection open interceptor
I am using ASP.NET Core and ADO.NET commands for SQL operations. I am looking for a way to intercept the SQL connection.Open() and then insert the UserID into the session_context prior to the ...
- 1,485
0
votes
0
answers
32
views
How to pass C# object as parameter to Oracle db using dapper (.NET8)
In .NET version 4.8, we added an object and executed the procedure like this:
List<OracleParameter> parameters = new List<OracleParameter>();
OracleParameter parameter = new ...
- 11
0
votes
0
answers
82
views
SqlClient error or authentication error randomly occurring of different application. Azure SQL Server database
Sometimes I see those errors in the logs and we are not able to understand which may be the root cause:
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.GetFedAuthToken(SqlFedAuthInfo ...
- 3,877
0
votes
1
answer
51
views
How to use SqlCommand, SqlDataReader SqlConnection etc. in Core .NET 6.0 [duplicate]
I am trying to access database using ADO.NET using below code
using System.Data;
using System.Data.SqlClient;
...........
.......
protected readonly SqlConnection conn = new SqlConnection();
protected ...
- 13
0
votes
3
answers
88
views
SQL Server connection is getting established and not disposed through ADO.NET / C#
I am using the code shown here, to connect to SQL Server. This is working properly, but for the past 2 days, I am facing an issue where multiple connections (~2000) are getting opened and not getting ...
- 334
0
votes
0
answers
90
views
Upgraded to VS 2022 and SSIS ADO.Net connections no longer work
I have upgraded from VS2019 to VS2022 and none of my ADO.NET connection mangers no longer work. My previous connections in VS2019 were SQLClient Data Provider. When I try and use those same connection ...
- 33
-1
votes
0
answers
58
views
Sqlite Select using ADO.net fails with System.ObjectDisposedException Cannot access a disposed object
public object? GetSync(string key) {
using var connection = new SqliteConnection(_connectionString);
connection.Open();
var selectQuery = $@"SELECT Value FROM {table} WHERE Key = @key&...
0
votes
1
answer
48
views
Finding RDBMS table relationships using SqlConnection schemas
I am writing an app in .NET 8 and using the Northwind database to generate stored-procedures, entity POCO classes, stored-procedure wrappers, controllers, etc.
Database Relationship Diagram:
In order ...
- 14.7k
1
vote
1
answer
86
views
How to update/add large amount of data into Oracle database from ASP.NET Core
I am working on an ASP.NET Core MVC application written in C#, where I have 2 jQuery datatables in a .cshtml view. I want to add and update large amount of data from these 2 jQuery datatables to the ...
- 39
0
votes
0
answers
60
views
Error connecting to DB2 using IBM.Data.DB2.iSeries
Trying to connect to DB2 using the Nuget pkg IBM.Data.DB2.iSeries 7.1.0 by Cristopher Gunn. The program throws an exception "The type initializer for 'IBM.Data.DB2.iSeries.iDB2Trace' threw an ...
- 50
1
vote
2
answers
76
views
Error when testing xUnit inserting a user into the database
I'm new to writing unit testing
I'm trying to write a unit test for inserting a user into a database but I'm getting an error
Error: System.NotSupportedException : Type to mock (SqlConnection) must be ...
- 13
0
votes
1
answer
40
views
C# OracleCommand return multiple DataTable as Output-Parameter with a single CURSOR
I have an SQL file that looks like this:
DECLARE
V_ID_CB VARCHAR2(15) := '{V_ID_CB}';
V_X_CB VARCHAR2(15) := '{V_X_CB}';
BEGIN
IF V_ID_CB IS NOT NULL THEN
OPEN :result_cursor FOR
...
- 1