I have 4 table
District(districtid(P),Districtname)
Tehsil(Tehsilid(P),Tehsilname,DistrictID(F))
UC(UCid(P),UCname,TehsilID(F))
Village(Villageid(P),Villagename,UCID(F))
F Stand for Foreign key and P for Primary key
I am using table value parameter for bulk insert but on each row I have to call a method to get the ID for example if i take an exmaple of saving the 200 villages the The village id comes from check box for for its UC I have to call a method in vb.net code and then this method get out the UC id of that village so it makes my process slow any solution????