DbFactory LastInsertIdSelectText Property NReco.Data Class Library Documentation
Gets or sets SQL command for retrieving ID for last inserted row.

Namespace: NReco.Data
Assembly: NReco.Data (in NReco.Data.dll) Version: 1.0.2
Syntax

public string LastInsertIdSelectText { get; set; }

Property Value

Type: String
Remarks

LastInsertIdSelectText for popular databases: MsSql (System.Data.SqlClient): "SELECT @@IDENTITY"Sqlite (Microsoft.Data.Sqlite): "SELECT last_insert_rowid()"PostgreSql (Npgsql): "SELECT lastval()"MySql (MySql.Data): "SELECT LAST_INSERT_ID()"
See Also