Bug 2391 - Can't get last inserted id while using SqlClient on mono [SQL SERVER]
Summary: Can't get last inserted id while using SqlClient on mono [SQL SERVER]
Status: NEW
Alias: None
Product: Class Libraries
Classification: Mono
Component: System.Data (show other bugs)
Version: 2.10.x
Hardware: PC Linux
: --- normal
Target Milestone: Untriaged
Assignee: Bugzilla
URL:
Depends on:
Blocks:
 
Reported: 2011-12-07 10:17 UTC by tomasz.kubacki
Modified: 2011-12-07 10:18 UTC (History)
1 user (show)

See Also:
Tags:
Is this bug a regression?: ---
Last known good build:


Attachments
test case (4.57 KB, application/octet-stream)
2011-12-07 10:18 UTC, tomasz.kubacki
Details

Description tomasz.kubacki 2011-12-07 10:17:02 UTC
Let's assume i'm inserting single row into SQL Server table with code like this:

cmd.CommandText = "insert into [User](name) values ('myName')";
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT SCOPE_IDENTITY()";
var res = cmd.ExecuteScalar();

I should get id in the res variable;

Under mono the res value is null whereas in the .NET i get last inserted id value.

i'm using sql server express 2008 R2 but run program on linux box

Issue should be very easy to reproduce using attached project
Comment 1 tomasz.kubacki 2011-12-07 10:18:13 UTC
Created attachment 1012 [details]
test case

Note You need to log in before you can comment on or make changes to this bug.