Running Insert/update SQL against ADO.NET dataset

[Matt]

So as you all know the great thing about ADO.NET is that I can take an
entire table from a database and dump it into an in memory datatable
using ADO.NET.

Well my question is that now that I have this temporary table, is it
possible to run SQL commands against it like it were an "actual"
table.

To give a simplistic example, lets say I have a table in my SQL Server
database called "Customers" that contains 2 columns (CustomerID,
CustomerName)

I dump that table into a ADO.NET object so now I have all of the rows
in that in memory datatable. Now I have this stored procedure that I
want to run against this in memory table. Would that be possible?

I know you can add a row by creating a datarow and doing it all
manually...but I much rather just run a stored proc.

Is this even possible??

[Spam Catcher]

Matt <Kr****@gmail.comwrote in news:b5204b80-548e-4e53-a5ab-
35**********@m36g2000hse.googlegroups.com:

So as you all know the great thing about ADO.NET is that I can take an
entire table from a database and dump it into an in memory datatable
using ADO.NET.

Yes, but that doesn't make it a great thing. In fact in most cases, it's
a downright bad thing!

Well my question is that now that I have this temporary table, is it
possible to run SQL commands against it like it were an "actual"
table.

You can do basic commands through a dataview. But no, it's not an in-
memory database with full SQL support.

LINQ however should be able to provide with the features you need.

I dump that table into a ADO.NET object so now I have all of the rows
in that in memory datatable. Now I have this stored procedure that I
want to run against this in memory table. Would that be possible?

No, stored procedures are for databases.

I know you can add a row by creating a datarow and doing it all
manually...but I much rather just run a stored proc.

Is this even possible??

Why not run the query against a DB instead of an in memory version?

--
sp**********@rogers.com (Do not e-mail)

[aaron.kempf]

I agree with the original question-- if it is an in-memory database--
why can't we submit queries to it?

COM+ with Windows 2000 pre-release included a seperate 'in-memory'
database but this was postponed until the release of .NET.

I think that a simple- in memory database- would be a lot of fun;
especially if it automatically synchronized and logged.

I don't thnk that most server databases really scale as well with
additional memory-- as it should.

Hhaving a 2gb database on a server with 4gb of ram-- everything should
be instant.

I'm not sure that SQL Server really is loose enough with memory.

Google has some in-memory database structures, I believe.

honestly http://code.google.com

-Aaron

On Apr 2, 12:21*pm, Spam Catcher <[e-mail]:

Matt <[e-mail] in news:b5204b80-548e-4e53-a5ab-
[e-mail]:

So as you all know the great thing about ADO.NET is that I can take an
entire table from a database and dump it into an in memory datatable
using ADO.NET.

Yes, but that doesn't make it a great thing. In fact in most cases, it's
a downright bad thing!

Well my question is that now that I have this temporary table, is it
possible to run SQL commands against it like it were an "actual"
table.

You can do basic commands through a dataview. But no, it's not an in-
memory database with full SQL support.

LINQ however should be able to provide with the features you need.

I dump that table into a ADO.NET object so now I have all of the rows
in that in memory datatable. *Now I have this stored procedure that I
want to run against this in memory table. *Would that be possible?

No, stored procedures are for databases.

I know you can add a row by creating a datarow and doing it all
manually...but I much rather just run a stored proc.

Is this even possible??

Why not run the query against a DB instead of an in memory version?

--
[e-mail] (Do not e-mail)

[Cor Ligthert[MVP]]

Matt,

If you create only a table, then you need only to add an insert command to
the insertcommand part of a dataadapter and a transact SQL insert command,
than can be either a stored procedure or in line in the command code (If it
is a small project that is in my opinion advisable, is it a huge solution
then I would use a stored procedure).

It is just
A DataTable where new rows are inserted,
A SQLDataAdapter
A SQL transact insert string
A SQL connection
A SQLCommand that has set its properties with that
Adding the later to the adapter
Doing a SQLDataAdapter Update with the table

Cor

"Matt" <Kr****@gmail.comschreef in bericht
news:b5**********************************@m36g2000 hse.googlegroups.com...

So as you all know the great thing about ADO.NET is that I can take an
entire table from a database and dump it into an in memory datatable
using ADO.NET.

Well my question is that now that I have this temporary table, is it
possible to run SQL commands against it like it were an "actual"
table.

To give a simplistic example, lets say I have a table in my SQL Server
database called "Customers" that contains 2 columns (CustomerID,
CustomerName)

I dump that table into a ADO.NET object so now I have all of the rows
in that in memory datatable. Now I have this stored procedure that I
want to run against this in memory table. Would that be possible?

I know you can add a row by creating a datarow and doing it all
manually...but I much rather just run a stored proc.

Is this even possible??

[Matt]

Cor -

I'm not looking to update the original database table via the
dataadapter. I'm looking to update the in memory datatable with the
insert command. Will that still work?

Everyone -

Basically I have a folder full of stored procedures that I want to run
against an in memory database.

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Matt,

You don't have an in-memory database and you can't run stored procedures
against datatables.

Kerry Moorman
"Matt" wrote:

Cor -

I'm not looking to update the original database table via the
dataadapter. I'm looking to update the in memory datatable with the
insert command. Will that still work?

Everyone -

Basically I have a folder full of stored procedures that I want to run
against an in memory database.

[aaron.kempf]

Well that is how ADO.net is presented to us. As an in-memory
database.
It seems to me like you should be able to write optimized Stored
Procedures to work against this IMDB.

In my opinion-- ADO.net can't even keep a connection _OPEN_.
Now _THAT_ is helpful.

-Aaron

On Apr 3, 7:43*am, Kerry Moorman
<[e-mail]:

Matt,

You don't have an in-memory database and you can't run stored procedures
against datatables.

Kerry Moorman

"Matt" wrote:

Cor -

I'm not looking to update the original database table via the
dataadapter. *I'm looking to update the in memory datatable with the
insert command. *Will that still work?

Everyone -

Basically I have a folder full of stored procedures that I want to run
against an in memory database.- Hide quoted text -

- Show quoted text -

[Steve Gerrard]

Matt wrote:

Cor -

I'm not looking to update the original database table via the
dataadapter. I'm looking to update the in memory datatable with the
insert command. Will that still work?

Everyone -

Basically I have a folder full of stored procedures that I want to run
against an in memory database.

Written in what? Oracle stored procedures only work in Oracle; SQL Server stored
procedures only work in SQL Server. PL/SQL is not the same as T/SQL.

For ADO.Net, you write your "stored procedures" in - you guessed it - .Net.