Click here to Skip to main content
15,892,537 members
Please Sign up or sign in to vote.
3.50/5 (4 votes)
See more:
Hi Everyone,

I found that SqlHelper class made development easy as well as cost effective. I am trying to build new project which will contain most of Helpers classes to make a developer's life easy. I want your recommendation and suggestions for this project, which you may use or want to use.

It might not be consider as question, but important.


Regards,
Aman
Posted
Comments
V. 16-Apr-12 5:16am    
SqlHelper is that something you wrote yourself? I'm guessing you want to create a 'framework' assembly with often used functionality, right?
Aman4.net 16-Apr-12 5:32am    
Yes, I want to create a group of assemblies which help to perform often used functionalities. I am talking about SqlHelper which is a part of Microsoft.Application.Block.
V. 16-Apr-12 7:39am    
Did you use the reply button? I happened to check back on this, but I never received a notification.

1 solution

You're talking about a "Framework", "Tools", "Utilities", ...
I've made a few myself, although I don't claim to be an expert, here are my recommendations:

- If possible avoid references of other assemblies that need local copy, if you just have one, you could possibly live with it, but if you start referencing assemblies all over the place it will cause a nightmare (dll hell etc...)

- Try to group functionality together eg. Database access, XML handling, Configuration, Logging, etc...

- What's in a name? Everything! Make sure you have a nice namespacing convention. Note that sooner or later you might need to include a third-party product that also has an assembly with name "XYZ". I often use something like CompanyName.Framework.Functionalitygroup

- Note that you can create a framework solution with multiple projects, effectively creating multiple assemblies which you could reference seperately if you want.

- Add the assemblies to the GAC (implies strong naming), else you just end up copying files all over the place and especially if you're working in a team, you'll end up in tears.

- If you're using the Enterprise assemblies from Microsoft, stay 100% Microsoft, if not (you need to use Oracle for example) don't use it.

- These assemblies are probably used very often, test them over and over and over again and make sure you do performance and load tests.

Hope this helps.

(PS: countered the 1 vote)
 
Share this answer
 
Comments
VJ Reddy 16-Apr-12 7:53am    
Good suggestions. 5!
Aman4.net 16-Apr-12 8:38am    
Thank you for such good recommendations. I will keep things in mind during development.

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