Getting auto-generated PK value back

[David Thielen]

I was told in another post that after inserting a row with an autogenerated PK, I can get the PK value back using LAST_INSERT_ID() or mysql_insert_id().

Is the way to do this:
cmd.CommandText = "insert into Schedule (sTitle, sDescription) values ('my sched', 'all about it'); LAST_INSERT_ID()";
object rtn = cmd.ExecuteScalar();
return (long)(decimal)rtn;

thanks - dave

ps - I am asking instead of trying because I am still waiting on the DBA to convert our schema from SqlServer to MySql (is there a tool that does this other than ErWin? Something not a fortune so I can get it for myself and not have to wait?).