tags:

views:

18

answers:

1
Q: 

SqlServerCE: TableAdapter + @@identity

Hi!

How do I get id of an insert query? Simple:

insert into Ex(sth) values("value");
select @@identity

does not work. When I try to ExecuteScalar or any other I get exception: {"There was an error parsing the query. [ Token line number = 3,Token line offset = 95,Token in error = select ]"}.

I remind this is the CE edition. I'm using MSVS2010

Thanks for your help.

A: 

The .Net SQL CE client does not support multiple statements.
You need to use two separate SqlCeCommands.

SLaks  2010-10-19 00:20:25
well... but you cannot do it in separated queries while you get null from the Select. Are there any other solutions to the problem? I mean - getting id previously inserted row.
SOReader  2010-10-19 00:25:10
I'm not sure. You could use a GUID (from the client) instead.
SLaks  2010-10-19 00:29:36
Ok, got it but still smth is remaining :/ TableAdapter automaticaly closes its connection after query, so quering for @@identity doesn't make any sense - the query has to be made on the same connection - that's what I made. Unfortunately you lose the benefits of the visual editor, while you have to write additional function by your own ;(
SOReader  2010-10-19 00:54:04

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?