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 ()
Version: 2.10.x
Hardware: PC Linux
: --- normal
Target Milestone: Untriaged
Assignee: Bugzilla
Depends on:
Reported: 2011-12-07 10:17 UTC by tomasz.kubacki
Modified: 2011-12-07 10:18 UTC (History)
1 user (show)

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

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

Notice (2018-05-24): bugzilla.xamarin.com is now in read-only mode.

Please join us on Visual Studio Developer Community and in the Xamarin and Mono organizations on GitHub to continue tracking issues. Bugzilla will remain available for reference in read-only mode. We will continue to work on open Bugzilla bugs, copy them to the new locations as needed for follow-up, and add the new items under Related Links.

Our sincere thanks to everyone who has contributed on this bug tracker over the years. Thanks also for your understanding as we make these adjustments and improvements for the future.

Please create a new report for Bug 2391 on GitHub or Developer Community if you have new information to add and do not yet see a matching new report.

If the latest results still closely match this report, you can use the original description:

  • Export the original title and description: GitHub Markdown or Developer Community HTML
  • Copy the title and description into the new report. Adjust them to be up-to-date if needed.
  • Add your new information.

In special cases on GitHub you might also want the comments: GitHub Markdown with public comments

Related Links:

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.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