Sha256: e958ba9b4bde684caf0a21470387ed4d264405c834f07f2dd42856fecad9e092
Contents?: true
Size: 985 Bytes
Versions: 7
Compression:
Stored size: 985 Bytes
Contents
Sequel.require 'adapters/shared/mssql'
module Sequel
module ADO
# Database and Dataset instance methods for MSSQL specific
# support via ADO.
module MSSQL
module DatabaseMethods
include Sequel::MSSQL::DatabaseMethods
# Return instance of Sequel::ADO::MSSQL::Dataset with the given opts.
def dataset(opts=nil)
Sequel::ADO::MSSQL::Dataset.new(self, opts)
end
end
class Dataset < ADO::Dataset
include Sequel::MSSQL::DatasetMethods
# Use a nasty hack of multiple SQL statements in the same call and
# having the last one return the most recently inserted id. This
# is necessary as ADO doesn't provide a consistent native connection.
def insert(*values)
return super if @opts[:sql]
with_sql("SET NOCOUNT ON; #{insert_sql(*values)}; SELECT CAST(SCOPE_IDENTITY() AS INTEGER)").single_value
end
end
end
end
end
Version data entries
7 entries across 7 versions & 2 rubygems