Click here to Skip to main content
15,916,288 members
Home / Discussions / C#
   

C#

 
GeneralRe: Directory Contents Change Comparison Pin
Jammer12-Nov-08 9:22
Jammer12-Nov-08 9:22 
GeneralRe: Directory Contents Change Comparison Pin
Pete O'Hanlon12-Nov-08 9:30
mvePete O'Hanlon12-Nov-08 9:30 
GeneralRe: Directory Contents Change Comparison Pin
Jammer12-Nov-08 9:31
Jammer12-Nov-08 9:31 
QuestionCrystal report - urgent Pin
muharrem12-Nov-08 2:24
muharrem12-Nov-08 2:24 
AnswerRe: Crystal report - urgent Pin
Paul Conrad12-Nov-08 3:39
professionalPaul Conrad12-Nov-08 3:39 
Questioninsert in a stored procedure Pin
swjam12-Nov-08 1:46
swjam12-Nov-08 1:46 
AnswerRe: insert in a stored procedure Pin
Ashfield12-Nov-08 2:13
Ashfield12-Nov-08 2:13 
AnswerRe: insert in a stored procedure Pin
Simon P Stevens12-Nov-08 3:07
Simon P Stevens12-Nov-08 3:07 
There's lot of ways.

Stored procedure
Parametrized query
ORM layer (Like NHibernate, LinqToSql or the Entity Framework)

A lot of people will argue SPs are better because the server optimises them. This is not true, modern database servers cache the execution plan for normal queries just as they do for stored procedures. It pretty much comes down to personal preference between the two. (Personally I prefer parametrized queries, I find them easier to maintain than SPs, but everyone has a different opinion on this)

An ORM is likely to be slightly slower, but will give you better abstraction and you won't have to write too much DAL code. Although they often require a lot of configuration will some form of GUI or XML based tool. Sometimes you can auto generate the ORM config by pointing it the database.

Simon

AnswerRe: what do i put in the primary key value in my insert clause? Pin
swjam12-Nov-08 4:07
swjam12-Nov-08 4:07 
GeneralRe: what do i put in the primary key value in my insert clause? Pin
J4amieC12-Nov-08 4:58
J4amieC12-Nov-08 4:58 
QuestionDijkstra shortest path Help Pin
dudz198712-Nov-08 1:31
dudz198712-Nov-08 1:31 
AnswerRe: Dijkstra shortest path Help Pin
Simon P Stevens12-Nov-08 2:59
Simon P Stevens12-Nov-08 2:59 
Questionaccess store procedure Pin
George_George12-Nov-08 1:30
George_George12-Nov-08 1:30 
AnswerRe: access store procedure Pin
Simon P Stevens12-Nov-08 2:57
Simon P Stevens12-Nov-08 2:57 
GeneralRe: access store procedure Pin
George_George12-Nov-08 21:32
George_George12-Nov-08 21:32 
GeneralRe: access store procedure Pin
Simon P Stevens12-Nov-08 21:43
Simon P Stevens12-Nov-08 21:43 
GeneralRe: access store procedure Pin
George_George13-Nov-08 0:01
George_George13-Nov-08 0:01 
GeneralRe: access store procedure Pin
Simon P Stevens13-Nov-08 0:59
Simon P Stevens13-Nov-08 0:59 
GeneralRe: access store procedure Pin
George_George14-Nov-08 1:21
George_George14-Nov-08 1:21 
Questionhow to use the toolbar button tag property during a toolbar click event Pin
swjam12-Nov-08 1:30
swjam12-Nov-08 1:30 
AnswerRe: how to use the toolbar button tag property during a toolbar click event Pin
V.12-Nov-08 1:55
professionalV.12-Nov-08 1:55 
QuestionC# exception definition Pin
George_George12-Nov-08 0:34
George_George12-Nov-08 0:34 
AnswerRe: C# exception definition Pin
Ravi Bhavnani12-Nov-08 1:03
professionalRavi Bhavnani12-Nov-08 1:03 
GeneralRe: C# exception definition Pin
George_George12-Nov-08 1:25
George_George12-Nov-08 1:25 
GeneralRe: C# exception definition Pin
Ravi Bhavnani12-Nov-08 7:27
professionalRavi Bhavnani12-Nov-08 7:27 

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.