Questions tagged [system.data]

System.Data is a namespace of the .NET framework. It provides access to classes that represent the ADO.NET architecture.

System.Data is a namespace of the .NET framework. It provides access to classes that represent the ADO.NET architecture.

References

161 questions
3
votes
4 answers

Create custom driver for System.Data.Common

Background: Our C# application generates and executes queries to several types of databases (Oracle, SQL Server, MySQL), but a requirement came up to also apply them to a proprietary file format. The namespace used until now is…
Markos Fragkakis
  • 7,499
  • 18
  • 65
  • 103
3
votes
0 answers

Visual Studio Entity-Framework-Designer: Update model from database broken by custom provider

We have decorated the default Entity Framework provider to support custom ExpressionsVisitors. So far everything works out the way we intend it to be. After adding the custom provider entry into the machine.config and placing the Custom Provider…
Chris Richner
  • 2,863
  • 2
  • 26
  • 38
3
votes
1 answer

Is there a limit to the number of DataColumns I can add to a DataTable?

I can't find any references to there being a limit to the number of DataColumns I can add to a DataTable. The DataTable will not be generated from a SQL query, but rather synthesized from other data. Thanks, Matthew
Matthew Belk
  • 1,904
  • 2
  • 20
  • 28
3
votes
2 answers

System.Data missing in F# project

I'm targeting .NET 3.5, but cannot get System.Data to come up in Intellisense. What am I missing?
James
  • 6,471
  • 11
  • 59
  • 86
3
votes
1 answer

Call GetStoredProcCommand with variable number of arguments in C#?

In my code I am repeating code blocks like this all the time: var returnData = MyDb.ExecuteDataSet( MyDb.GetStoredProcCommand("MyTable_Insert", columnOne, columnTwo, columnThree), transaction ); var returnId =…
Robin Winslow
  • 10,908
  • 8
  • 62
  • 91
3
votes
1 answer

How can i copy data table records of different field name based on mapping list evaluating condition on source data table?

I have a Source Data table of type System.Data.DataTable from which i have to generate Destination Data Table of mapped column(Consider same SqlDBType for mapped columns.) I have a list of MappingInfo class in which each Source Datatable Column…
binarymnl
  • 153
  • 2
  • 12
3
votes
3 answers

What does "Child list for field ... cannot be created" mean?

My C# coded application uses an Infragistics.Win.UltraWinGrid.UltraGrid to display some data. The data is basically a collection of computers. The application is able to filter these computers (like "Workstations", "Servers" etc) for viewing. This…
Corpsekicker
  • 3,276
  • 6
  • 25
  • 34
3
votes
1 answer

System.Data.DataSetExtensions doesn't exist in the Mono for Android profile

I have imported a third party .net library into my Mono for Android project that uses the DataSetExtension library. When I try to compile I get the following errormessage: Error 51 Exception while loading assemblies:…
3
votes
1 answer

WinRT System.Data - Connect to SQL

Just want to make sure I am not missing something. There does not appear to be a WinRT System.Data. What I am looking for is System.Data.SqlClient to connect to SQL. Can a Metro App connect to SQL? If yes can a Metro App connect to SQL in a App…
paparazzo
  • 44,497
  • 23
  • 105
  • 176
2
votes
2 answers

Autogenerated enum definition causing problems on client side

I have a situation like this, where i have WCF Service (VS2008) Hosted somewhere Main Solution (VS2005) which has a Consumer Project of type 'class Library' with the Service reference to this WCF Service In the data Contract i have a Data Member …
Bravo
  • 3,341
  • 4
  • 28
  • 43
2
votes
2 answers

How can I get fluent nhibernate working in .net 4

I am using all the dlls from the standard fluent nhibernate download, as well as the standard sqlite dll. It only works if I switch target framework to 3.5 -- in which case the reference for system.data is switched to version 2. -- so this dll is…
the_law
  • 215
  • 1
  • 5
  • 13
2
votes
1 answer

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 namespace name 'PluralizationService' could not be…
Level 42
  • 400
  • 2
  • 7
2
votes
0 answers

Does SQL Server keep running a stored procedure after the client program's SqlCommand.ExecuteNonQuery() CommandTimeout expires?

What happens to a SQL Server stored procedure that was initiated by a client C# program's call to the SqlCommand.ExecuteNonQuery method after the CommandTimeout expires? Does SQL Server continue running the stored procedure to completion (even…
Jon Schneider
  • 25,758
  • 23
  • 142
  • 170
2
votes
3 answers

After importing DataSet from XML, new rows are not nested properly

I'm using DataSet.ReadXml() to import an XML file into a new DataSet. Then I'm adding a new row to one of the tables inside the DataSet, and then I want to export that DataSet to XML again. The problem is that the new row is not nested properly and…
DotNetPadawan
  • 1,026
  • 7
  • 10
2
votes
1 answer

create table with records in sql server with powershell: what's best?

I need to create and populate a table on sql server db starting from a powershell array of objects coming from select-object. I need to create the table with the correct datatypes and fields. One way that I well know is export-csv and then…
Emiliano Poggi
  • 24,390
  • 8
  • 55
  • 67
1 2
3
10 11