Create Data layer Class

Question

0.00/5 (No votes)

See more:

, +

Hello

i need help plz , How can i create Data layer Class that make me work with object from this class as aDataBase Table .

for Example: ClassDB MyClass = new ClassDB("dbo.Tbl1");

and from this class i can handle any task with the Data Base (Insert -Updatee-Delete-Select -Etc......)

hope that i can explane it well

waiting for the answer

Best Regards

Posted 9-Jul-11 23:24pm

ehab_developer

Add a Solution

3 solutions

Add a Solution

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

Abhinav S · Answer 1 · 2011-07-09T23:30:00

Solution 1

This[^] tutorial is perhaps a very detailed one that should help you out.

Posted 9-Jul-11 23:30pm

Abhinav S

Comments

Monjurul Habib 10-Jul-11 5:48am

nice link, my 5.

Abhinav S 10-Jul-11 5:55am

Thank you.

ehab_developer 17-Jul-11 9:26am

Hello
First i'm sorry for late , second what i need is DAL Completed class that depend on Writing Code and stored procedures and an example of how can i implement it , Thanks

Abhinav S 17-Jul-11 10:21am

There are a couple of links that could help you out -
http://www.codeproject.com/KB/cs/dalmethodcodegenerator.aspx
http://www.codeproject.com/KB/database/Lightweight_DAL_in_NET_2.aspx

But seriously, you should give it a try on your own.

ehab_developer 20-Jul-11 8:57am

I gonna Check it Thanks

Monjurul Habib · Answer 2 · 2011-07-09T23:48:00

Solution 2

Another link here
OR
Have a look here.

Posted 9-Jul-11 23:48pm

Monjurul Habib

Comments

Abhinav S 10-Jul-11 5:55am

Yup good links. My 5.

Monjurul Habib 10-Jul-11 12:01pm

Thank you.

ehab_developer 17-Jul-11 9:26am

Hello First i'm sorry for late , second what i need is DAL Completed class that depend on Writing Code and stored procedures and an example of how can i implement it , Thanks

mahabubur rahman · Answer 3 · 2011-07-10T00:20:00

Solution 3

use LINQ to SQL for any kind of database operation (Insert, Update, delete etc). for sample code of Linq to sql visit
Accessing Data using Language Integrated Query (LINQ) in ASP.NET WebPages – Part 2[^]
LINQ to SQL: Basic Concepts and Features[^]
LINQ to SQL[^]

Thanks

Posted 10-Jul-11 0:20am

mahabubur rahman

Comments

ehab_developer 17-Jul-11 9:31am

Hello
First i'm sorry for late , i'm little new with Linq but i gonna check ur links , but plz can any one tell me what the best way to work with database and the applied way by the professionals work by dataset or wizard like it(Without Writing Code) or writing C# Code ,Thanks

Create Data layer Class

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Create Data layer Class

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us