You've not provided enough information. What's the query look like? What is "Dealer?" A table or stored procedure?
I cannot think of any reason that ADO .NET would not be able to deal with @@IDENTIY?
>.NET datatable doesn't return identity.
>
>ds=sqlData.runsql(strSql,"Dealer")
>dt=ds.tables(0)
>dim idx as integer = dt.rows(0)(0)
>return idx
>
>idx is dbnull always with .NET
>
>If I run the query in Query Analyzer, I get the proper id# for my auto-increment primary key id field right after running an INSERT command.
>
>Does .NET dataset not support the @@identity?
>
>How would I get the last created id?
>
>Thanks,