see this page:

http://www.adefwebserver.com/DotNetNukeHELP/Misc/code/DynamicForms_DynamicForms_DAL.vb.htm

     Public Shared Function AddNewRecord(ByVal PortalID As Integer) As Integer
            Dim i As Integer = 0
            Dim mySqlString As New StringBuilder()
 
            mySqlString.Append("INSERT INTO {databaseOwner}{objectQualifier}DynamicForms_Records ")
            mySqlString.Append("(PortalID, RecordName) ")
            mySqlString.Append(" VALUES (@PortalID,'');Select SCOPE_IDENTITY() as myIdentity ")
 
            Dim parmPortalID As SqlParameter = New SqlParameter("@PortalID", SqlDbType.Int, 4)
            parmPortalID.Value = PortalID
 
            Using dr As IDataReader = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), parmPortalID), IDataReader)
                While dr.Read
                    i = Convert.ToInt32(dr.Item("myIdentity"))
                End While
            End Using
 
            Return i
        End Function

Thanks for the info Michael.

I'll be getting into the Linq arena soon. For now I created a stored procedure that fires in the objectdatasource_Item_Inserted event. It grabs the MAX(ID) WHERE UserID = @MemberID. It works and once I get the Linq stuff going I'll take another look at it.

Thanks again!