Enteprise Library Data Access @@Identity

[Liming]

Hello all,

I have a need to use "select @@identity" to get the auto id on the row
that I just inserted. But for some reason, I always get back 0. I used
MS Access. Please advice.

Database InvestmentsDb = DatabaseFactory.CreateDatabase( "Investments"
);
using (IDbConnection connection = InvestmentsDb.GetConnection())
{
connection.Open();
IDbTransaction transaction = connection.BeginTransaction();
try{

DBCommandWrapper Proc_Login_Insert =
InvestmentsDb.GetStoredProcCommandWrapper(this.pro c_Logins_Insert); Proc_Login_Insert.AddInParameter("@UserName",
DbType.String,
this.userName); Proc_Login_Insert.AddInParameter("@Password",
DbType.String,
this.password); Proc_Login_Insert.AddInParameter("@Email",
DbType.String, this.email);
Proc_Login_Insert.AddInParameter("@RoleType", DbType.String,
"investor");
InvestmentsDb.ExecuteNonQuery(Proc_Login_Insert, transaction);

String id = "";
id =
Convert.ToString(InvestmentsDb.ExecuteScalar(Comma ndType.Text,"Select
@@Identity"));
log.Debug("Id is:"+id);
.....
....
....

[Liming]

never mind. my ExecuteScale wasn't part of the transaction and i added
it in, it works

[rviray]

forgive my ignorance, I am not an Access guru...however, I have only
used @@Identity in store procs right after I run the insert
statement...also, "Select @@Identiy" <-- how does it know which table
your talking about?

Anyway, why couldn't you run a select statement (after your insert
statement) like "Select top 1 idColumn from tbl order by idColumn desc"
(once again, I don't know if Access has a "TOP" keyword...)

Sorry I couldn't be more help...
--
rviray
------------------------------------------------------------------------
rviray's Profile: http://www.msusenet.com/member.php?userid=4211
View this thread: http://www.msusenet.com/t-1871084818