C# (CSharp) System.Data.Common DbCommand.Execute Examples

Example #1

File: SqlServerCEProvider.cs Project: eugman/SqlFu

 public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
 {
     cmd.Execute();
     cmd.Reset();
     cmd.CommandText = "select @@IDENTITY as id";
     var rez = cmd.GetRawValue();
     return new LastInsertId(rez);
 }

Example #2

File: SQLiteProvider.cs Project: rajeshpillai/SqlFu

 public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
 {
     if (idKey != null)
     {
         cmd.CommandText += ";SELECT last_insert_rowid()";
         var rez = cmd.GetRawValue();
         return new LastInsertId(rez);
     }
     cmd.Execute();
     return LastInsertId.Empty;
 }