Industry standard in DAL datasets?

Question

Hi In my DAL there are classes to authenticate users and to perform CRUD operations. Assume there are two main fucntions as mentioned user Authentication and CRUD operations i could automate CRUD operations from wizard and for this i have to create a dataset that may have two or three tables. Authenticate is another fuction.. for this i need to another table..... Do i need to create a Dataset in it should i implement my Database with all relationships? Or Should i create two datasets one ONLY to perform user authentication and another to do all CRUD operations? TY

petre ricardo · Answer

Are you saying that a Datset object can be used as a DAL? Since very recenlt i used this Dataset design using the Wizard... prior to that i was doing BLL and DAL all by code and i used my own way of dealing with concurrencies... However i had to quit that method due mitchmatch with industry standards... At the moment i'm using the Wizard Designed Datasets in my DAL as a part of my DAL then i make the DAL communicate wiht BLL... I hope it's good idea to use Dataset as a part of DAL? I havent moved in to LINQ yet well not with seriouse applications.... If i use LINQ where does this wizard designed Dataset fits in? TY

Kirtan Patel · Answer

it will not exposed to out side world with data set but you have to define all the relation ship as per the database. in industry they are used as requirement if project is highly customizable then better to use code then data set because code is easy to configure then data set and DataSet have some limitations at customization . if project needs high customization then better to build Class Based DAL :) if my answer helps you then Check Do you like this answer  :)

petre ricardo · Answer

Actually two questions: 1. If i use the wizard to create Optimistic Concurrency enabled Dataset Do i have to create a copy of the database with all tables in it in my Dataset(with all the relationship).. if i create this database model in my dataset...thsi would expose alot of sensitive information to the outside...? 2. If i use the code i dont have to worry about these relationships in teh dataset however i dont expose the database to the outside world through dataset... therefore which one is used in the industry? TY

Kirtan Patel · Answer

Friend Could Not Understood you can you explain more clearly :)? do you mean that If you Create DataSet Intead of Creating Class then you have to Create Relation Ships Amonf Dataset tables ??