|
What is the difference between data adapter and data reader?
Answer Snippets (Read the full thread at stackoverflow):
Please see DataReader, DataAdapter & DataSet - When to use? :
ADO.NET provides two central Data.
|
|
We are building an ASP.NET MVC site, and I'm struggling with where to define a connection to best enable unit testing (I use 'connection' generically - it could be a session, a connection, an adapter, or any other type of data context that can manage ...
Started by LuckyLindy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I am using DI (with Ninject to make things more comfortable, but you can do on the very same subject last week :-)
I instantiate the data context inside a very thin wrapper and put "where to instantiate a data....
Of a real data context.
|
|
My ASP.NET web application is not recognizing DataSet and DataAdapter. Which namespace is required to create a new DataSet?
Answer Snippets (Read the full thread at stackoverflow):
Well, you are going to need to....
Namespace
using System.Data;
OR Directly
System.Data.DataSet ds = new System.Data.DataSet();
System.Data
For a typed DataSet, you can check the typed DataSet file's (.XSD file) .CS/.VB file; it will show the namespace .
|
Ask your Facebook Friends
|
I am getting this error but only very occasionally. 99.9% of the time it works fine:
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Does anyone have any idea on what the cause could...
Started by horatio on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Visual Studio will automatically read schema and try and set up some primary keys on your dataset, but if you are using a view that can possibly return... .
This typically happens when the schema on your dataset is enforcing something that your database is not .
|
|
Hi,
Can someone tell me why I would use a query adapter within the dataset designer instead of adding queries to the table adapter?
Regards
Started by Ace Grace on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can define as many queries for a TableAdapter as your application requires, as long as each query returns... .
Unlike standard data adapters, TableAdapters can contain multiple queries to fill their associated data tables.
Of fields.
|
|
I'm using a table adapter in Visual Studio to make a query to a stored procedure in my SQL Server 2005 database. When I make the call via my website application it returns nothing. When I make the same call via SQL Server Manager it returns the expected...
Started by Cptcecil on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Make sure each variable has....
Visual Studio can be funny with query parameters.
This has helped me many times.
Use Sql Profiler to see how the sql sent to sql server actually looks like .
Dates need to have quotes around them in SQL else they don't work .
|
|
Private static void InsertToLocalSqlTallyData(DataSet TallyDataSet) { DataSet SqlTallyDataSet=new DataSet(); SqlTallyDataConnection = new SqlCeConnection("Data Source=|DataDirectory|\\TallyData.sdf;Persist Security Info=False;"); SqlTallyDataConnection...
Answer Snippets (Read the full thread at microsoft):
SqlTallyDataConnection = new SqlCeConnection("Data Source=|DataDirectory|\\TallyData.sdf;Persist already explained that Sql Data base requires the ExecuteNonQuery();
in one of your posts.
|
|
What is difference between Bridge and Adapter pattern where i can use which pattern.
Started by Firoz on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Http://en.wikipedia.org/wiki/Adapter%5Fpattern
The Adapter pattern is more about getting your, imagine if you had a few implementations of a data store: one is efficient in space, the other believe you need to use one or the other....
|
|
I ran across this bug three times today in one of our projects. Putting the problem and solution online for future reference.
impost psycopg2 con = connect(...) def save(long_blob): cur = con.cursor() long_data = struct.unpack('<L', long_blob) cur....
Started by Great Turtle on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Impost psycopg2 con = connect(...) def save(long_blob): cur = con.cursor() long_data = struct.unpack....
[0] cur.execute('insert into blob_records( blob_data ) values (%s)', [long_data])
"Can't adapt adapt" error message.
|
|
When using the mainframe DB2 adapter for Microsoft BizTalk 2009, is there any way to get the generated schema to contain all the columns in the result set?
We get a simple schema generated, the response contains a record/element called "ResultSets" with...
Started by NealWalters on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Discover anything new in regards to using the DB2 adapter and the response ResultSets node, please let me.
|
