164 questions
0
votes
0
answers
37
views
DbDataAdapter.Fill crashes internally with NullReferenceException
Basically, when I'm trying to get data from db by calling DbDataAdapter.Fill(dataTable);
very rarely, this call just crashes internally with NullReferenceException.
I hooked a symbols to try to debug ...
- 211
0
votes
0
answers
88
views
Failed to resolve assembly: 'System.Data.Common, Version=0.0.0.0, Culture=neutral, ...'
In my C# .Net Framework v4.8 project, I have installed few packages including Nunit console runner and Dapper. When i build i am not getting any error but in jenkins while intrumenting i am getting ...
-1
votes
1
answer
394
views
Latency on Azure SQL Server vs. Fabric Datawarehouse SQL Server
Azure SQL Server vs. Fabric Datawarehouse SQL Server
I'm in the process of moving an application's data source from Azure SQL Server to a Fabric Datawarehouse.
However, it seems like latency is a huge ...
- 51
4
votes
2
answers
1k
views
Using System.Data.Sqlclient instead of Microsoft.Data.SqlClient when connecting to a Fabric datawarehouse
Using this example:
https://robkerr.ai/query-fabric-table-csharp/
I can connect to my sqlserver Fabric Warehouse in Azure trough VS Code when using Microsoft.Data.SqlClient
My question is this : Is ...
- 51
0
votes
0
answers
251
views
On a update (There is already a parameter with the name '@xxxxxxx' in this collection.)
I am using VB.NET, Visual Studio 2022, Win 10, MySQLConnector.dll (2.2.6.0)
I am trying to integrate MySQL into a framework that is a wrapper for ADO.net. Let me try and create some context.
This ...
- 101
0
votes
0
answers
43
views
System.Data.Common.Utils.Boolean equivalent in .net 6
There is a converter function in System.Data.Common.Utils.Boolean in .net Framework 4.8. I cannot find this namespace in .net 6. Does anybody know where it was moved to?
We are specifically looking ...
4
votes
2
answers
67
views
DataColumn renaming to only change casing causes a weird behaviour
I found a weird behaviour (a bug?) in .NET Framework and .NET when it comes to DataColumn renaming. Here's how to reproduce it.
Take a DataColumn in a DataTable
Rename it so that you only change its ...
- 41
0
votes
1
answer
108
views
How can I restore System.Data and other files missing from Windows\Microsoft.NET Folder, not restored by repair tool or turning features off and on?
Powershell:
Could not load file or assembly ‘System.Data, Version =4.0.0.0.
Culture=neutral, PublicKeyToken=b77a5c561934e089’ or one of its
dependencies. The system cannot find the file specified.
I ...
- 1
1
vote
1
answer
104
views
SqlGeography does not implement IComparable interface, preventing DataSet.RejectChanges() from succeeding
I'm working on an Enterprise application that has an SQL backend, and uses System.Data.DataSet etc to represent that data in C#.
Previously we turned the SqlGeography into DbGeography before putting ...
- 21.8k
-1
votes
2
answers
636
views
How to get the current date in DataTable.Compute
I am trying to compute the string expression by DataTable.Compute.
A simple string like below is working:
static void Compare()
{
var logicalExpression = "'2022-09-14' ...
- 29.9k
0
votes
1
answer
1k
views
DataRow.ItemArray does not have values and is empty
my DataRow object is emtpy no matter how I try to initialize it. Here is the source code:
private DataTable ReadFileIntoDb(MemoryStream file)
{
file.Position = 0;
var sr =...
- 137
0
votes
1
answer
2k
views
How to fix 'Cannot convert from 'string' to System.Data.SqlDbType' in a Windows Forms Application
This only happens when I created a basic login screen for a sample application I'm building. I have various other functions in the application that read/write/update rows in a database without errors.
...
- 21
0
votes
2
answers
567
views
DataRow.SetField() gives a null ref exception when adding data to a column I previously deleted then added back
UPDATE
I think I have found what is causing the issue here https://stackoverflow.com/a/5665600/19393524
I believe my issue lies with my use of .DefaultView. The post thinks when you do a sort on it it ...
- 31
3
votes
1
answer
2k
views
Where do I find System.Data.Entity.Design.PluralizationServices in .NET CORE 5.0
My .NET 4.0 app used the PluralizationServices located in System.Data.Entity.Design.PluralizationServices. When I went to convert my app to .NET CORE 5.0, the compiler complains:
The type or ...
- 412
-2
votes
1
answer
305
views
Simple select C# command - Beginner
Could you let me know where I am going wrong? I think its to do with the variable I have declared but I'm not sure
using System;
using System.Collections.Generic;
using System.ComponentModel;
using ...
- 1