visual studio lightswitch - Users and Employees table -

i in process of making database application, using lightswitch, tracks paperwork grouped batches. each of these batches has 1 or more batch_status associated it, , each batch_status has employee associated it.

i want programmatically insert batch_status when batch created , want match employee.username user.name want program work activedirectory permissions. ideas?

edit: btw i'm using lightswitch vb, not c#

i found own answer. i'll document useful others. created query , put code in batches_inserted sub under applicationdataservice:

       dim myquery = curruserquery(application.user.name)         each e employee in myquery         next