How to create common class and method in application for connection with sql server ?

Question

1.00/5 (1 vote)

See more:

I want to create common class for application in which i can create some methods for ado.net code. And I can access that methods in any c# file belongs to my project or application. Currently I am writing connectivity code on every c# file.
Please let me know the Idea with example
.

Posted 23-Jul-15 18:01pm

Veeshal Mali

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Accepted Answer · 2015-07-23T18:12:00

Solution 1

First of all don't store an open connection in a common class. It's better to open and close the connection during one call.

But what comes to the class itself, why not create a static class which doesn't need to be instantiated. So simply

C#

internal static class MyConnectionUtils [
   // here goes your methods
}

And when using it

C#

void MyMethod(SqlConnection connection) {
   // do something
   MyConnectionUtils.SomeMethod(connection);
   // do something
}

Posted 23-Jul-15 18:12pm

Wendelius

Comments

DamithSL 24-Jul-15 1:01am

how about Data Access Application Block [^], or with Nuget[^]

Wendelius 24-Jul-15 1:10am

Yes, those would probably be handy. But because the OP didn't explain what kind of functionality he's going to write I have no idea Data Access Application Block contains what he needs :)

Anyhow, thanks for pointing out!

DamithSL 24-Jul-15 1:33am

Yes, agreed. my5!

Wendelius 24-Jul-15 1:38am

Thanks :)

DamithSL 24-Jul-15 1:39am

you got my vote? it seems bug in CP, when I click on vote button it redirect to blank page.

Wendelius 24-Jul-15 1:46am

Looks like it wasn't applied for some reason... Perhaps you have used today's votes :)

DamithSL 24-Jul-15 1:57am

It looks like Bug[^]

Wendelius 24-Jul-15 2:06am

Ok, good that you've reported it :)

Sanket Saxena 24-Jul-15 1:11am

What do you think about DbProviderFactory? Can work with common and generalize classes for all almost all the applications.

DamithSL 24-Jul-15 1:33am

you mean DbProviderFactory? yes, can use if OPs looking for only creating instances of a provider's implementation of the data source classes, but Data Access block will help OP beyond that level. it all depends on what exactly OP need.

Sanket Saxena 24-Jul-15 1:37am

Exactly :)

Wendelius 24-Jul-15 1:37am

It would help if you would explain what you are about to do. It's quite impossible to answer on general level is something good for something :)

Sanket Saxena 24-Jul-15 1:39am

yeah as per OP requirement your solution work.
+5 :)

Maciej Los 24-Jul-15 2:00am

5ed!

Wendelius 24-Jul-15 2:06am

Thanks Maciej :)

Maciej Los · Accepted Answer · 2015-07-23T20:10:00

Solution 2

Seems you're looking for DAL[^] and BLL[^].

Useful links:
Tutorial 18: Handling BLL-Level and DAL-Level Exceptions in an ASP.NET Page[^]
Generic Data Access Layer - GDA: Part I[^]

Posted 23-Jul-15 20:10pm

Maciej Los