I am creating a transaction. I have done this before with unrelated tables. However, now I have related table. Say I have an "organization" table. Then I also have a "member" table, which has a foreign key to the "organization" table. If I add a new organization, I need the primary key of that record to then use on the INSERT for the "member" table. If this was not within a transaction, I would use SELECT Scope_Identity() and .ExecuteScalar to obtain the Primary Key.
How do I do this same thing within a transaction?