Click here to Skip to main content
14,699,570 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
See more:
Hi all

I ve 2 table one is master and another is transaction table
The master table is resume
the fields are 1.resume_id which is auto increment no
2.name
3.skill
4.phoneno
the transaction table is Document the fields are
1.document_id auto increment no
2.resume_id
3.file_type
4.file_content
5.property_id which is nullable

In the career page the file upload option is there with name,skill and phoneno when u click on submit the data of name,skill and phone no is saved in resume table with the resume _id.and that resume_id is again stored in document table with file_type of uploaded file.how i retrieve the resume_id using linq.


Anybody can write the store procedure for this
thank a lot in advance!
Posted
Updated 8-Dec-10 6:35am
v4

1 solution

You need to write LINQ query in order to fetch the max resume_id inserted in the Master table.

example:

int maxresumeID = (from resume in dbContext.Resume
                   select resume.resume_id).Max();
   
Comments
Starlene 8-Dec-10 7:59am
   
thnaks
Starlene 8-Dec-10 8:01am
   
hello can u write the store procedure for this.plz
Amit Kumar Tiwari 9-Dec-10 5:18am
   
Yes I can write that, but I would prefer you to write it. Otherwise how will you learn it.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900