Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I am looking for architecture like as follows:

Database --> DataSet --> DataContext(Linq)/ ORM Entity --> GUI Application

I want to fetch data from database and keep into DataSet so if database id disconnect my application doesn't affect.

But DataSet is not supporting Object-Relational-Mapping (ORM) Model. I am interested in ORM because I want to take the advantages of LINQ.

and finally on My GUI i want to access Entity Classes.

Please Explain this by taking example like

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.

Thanks
Posted

1 solution

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.
 
Share this answer
 

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