Click here to Skip to main content
15,899,632 members
Home / Discussions / C#
   

C#

 
GeneralRe: Abstract Class Pin
Calla26-Apr-10 1:07
Calla26-Apr-10 1:07 
GeneralRe: Abstract Class Pin
Eddy Vluggen26-Apr-10 1:20
professionalEddy Vluggen26-Apr-10 1:20 
GeneralRe: Abstract Class Pin
future383926-Apr-10 1:44
future383926-Apr-10 1:44 
QuestionHow to send & receive sms via gsm modem ? Pin
hdv21224-Apr-10 9:39
hdv21224-Apr-10 9:39 
AnswerRe: How to send & receive sms via gsm modem ? Pin
Md. Marufuzzaman24-Apr-10 20:35
professionalMd. Marufuzzaman24-Apr-10 20:35 
GeneralRe: How to send & receive sms via gsm modem ? Pin
hdv21225-Apr-10 10:34
hdv21225-Apr-10 10:34 
QuestionBest way for windows application with good performance , SQL & Oracle support? Pin
anand kumar m24-Apr-10 5:51
anand kumar m24-Apr-10 5:51 
AnswerRe: Best way for windows application with good performance , SQL & Oracle support? [modified] Pin
PIEBALDconsult24-Apr-10 6:42
mvePIEBALDconsult24-Apr-10 6:42 
The application should neither know nor care what database is in use. This is where the Data Access Layer shines -- it separates the application from the database. I prefer to have a database-agnostic framework (such as my DatabaseAccessor[^]) upon which to build the DAL. You can then build flexibility into your DAL to deal with the various flavors of SQL (which is a step I haven't bothered to take yet myself).

Given a proper DAL, the application developers won't know whether you are using stored procedures or not.


anand kumar m wrote:
Now I suppose to write procedures for both the databases. ... I feel this will cause maintanance issue in future as software size grows.


Yes, it will. The queries have to go somewhere, and there are differences in how SQL is implemented by various vendors. For ease of maintenance, the multiple versions of a particular query should be kept close together, in one file if possible. This tends not to be the case when using stored procedures. It's one of the things I like least about stored procedures (I don't use stored procedures anymore).


anand kumar m wrote:
Entity Framework & Linq to DB


Don't those only work with SQL Server? Either way, I avoid them.


The old ways are the best ways. Cool | :cool:


P.S. As to performance -- you still need to write good SQL and use Connections, Commands, and Parameters effectively.
Most "performance" problems are caused by poor understanding of the tools being used.

modified on Saturday, April 24, 2010 1:18 PM

Questionproblem with MSCHART spline graph! [modified] Pin
alibaba88s24-Apr-10 2:29
alibaba88s24-Apr-10 2:29 
AnswerRe: problem with MSCHART spline graph! Pin
Luc Pattyn24-Apr-10 2:57
sitebuilderLuc Pattyn24-Apr-10 2:57 
GeneralRe: problem with MSCHART spline graph! [modified] Pin
alibaba88s24-Apr-10 3:00
alibaba88s24-Apr-10 3:00 
GeneralRe: problem with MSCHART spline graph! Pin
Luc Pattyn24-Apr-10 3:08
sitebuilderLuc Pattyn24-Apr-10 3:08 
GeneralRe: problem with MSCHART spline graph! Pin
alibaba88s24-Apr-10 3:37
alibaba88s24-Apr-10 3:37 
GeneralRe: problem with MSCHART spline graph! Pin
alibaba88s24-Apr-10 3:41
alibaba88s24-Apr-10 3:41 
GeneralRe: problem with MSCHART spline graph! Pin
Luc Pattyn24-Apr-10 3:57
sitebuilderLuc Pattyn24-Apr-10 3:57 
GeneralRe: problem with MSCHART spline graph! [modified] Pin
alibaba88s24-Apr-10 4:06
alibaba88s24-Apr-10 4:06 
GeneralRe: problem with MSCHART spline graph! Pin
Luc Pattyn24-Apr-10 4:15
sitebuilderLuc Pattyn24-Apr-10 4:15 
GeneralRe: problem with MSCHART spline graph! Pin
alibaba88s24-Apr-10 4:25
alibaba88s24-Apr-10 4:25 
GeneralRe: problem with MSCHART spline graph! Pin
Luc Pattyn24-Apr-10 5:05
sitebuilderLuc Pattyn24-Apr-10 5:05 
GeneralRe: problem with MSCHART spline graph! Pin
alibaba88s24-Apr-10 5:28
alibaba88s24-Apr-10 5:28 
QuestionString manipulation Pin
Tichaona J24-Apr-10 1:27
Tichaona J24-Apr-10 1:27 
AnswerRe: String manipulation Pin
Luc Pattyn24-Apr-10 1:41
sitebuilderLuc Pattyn24-Apr-10 1:41 
AnswerRe: String manipulation Pin
Estys24-Apr-10 1:45
Estys24-Apr-10 1:45 
AnswerRe: String manipulation Pin
Md. Marufuzzaman24-Apr-10 1:46
professionalMd. Marufuzzaman24-Apr-10 1:46 
GeneralRe: String manipulation Pin
Tichaona J24-Apr-10 1:50
Tichaona J24-Apr-10 1:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.