Insert method always returned null for the primary key. Modified insert statement to append SQL to retrieve the identity generated. Changed the method used to execute the insert to .Query.