wrote:
I want to fetch data from database and keep into DataSet so if database id disconnect my application doesn't affect.
ALL datasets work thart way.
wrote:
I am interested in ORM because I want to take the advantages of LINQ.
LINQ works with SQL data. Your only issue is that it iterates over the data when it's asked for, which may mean it requests it from the DB later, which kills point A.
wrote:
1. College (Database Table)
College_id (Primary Key)
College_name
2. Student (Database Table)
Student_id (Primary Key)
Student_name
College_id (Foreign Key)
Student_mark
Design a GUI in One Drop Down List which contains College List and on College Selection it displays Student List (Student Id,name,mark) in GridView.
Ah - this is a convoluted way to try to get us to do your homework for you ? Forget about it. Do your own work. Also, assume your teacher knows how to use google and can find his questions when posted verbatim on the web. So, if I gave you code, and you passed it in, you would fail for sure. If there's any chance your teacher can tell who you are from your user id, you will still probably fail, unless you go to them, tell them what you did, and ask THEM for help.