Click here to Skip to main content
15,913,709 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Want to inherit one property to another Pin
BrokenS2-Nov-07 11:18
BrokenS2-Nov-07 11:18 
GeneralRe: Want to inherit one property to another Pin
Brad^2-Nov-07 11:21
Brad^2-Nov-07 11:21 
QuestionWeb Service in VB.Net created XML doc Pin
kendo172-Nov-07 9:58
kendo172-Nov-07 9:58 
QuestionHelp with an CR report... Pin
CCG32-Nov-07 9:48
CCG32-Nov-07 9:48 
QuestionHelp on Submit Form via Email Pin
cyepes272-Nov-07 9:30
cyepes272-Nov-07 9:30 
AnswerRe: Help on Submit Form via Email Pin
Christian Graus2-Nov-07 21:05
protectorChristian Graus2-Nov-07 21:05 
Questionhow to send an xml file wrapped in a cookie to other website using httpwebrequest? Pin
dreddy72-Nov-07 6:35
dreddy72-Nov-07 6:35 
QuestionIs strongly typed database code worth it? It's giving me a headache! Pin
MattPenner2-Nov-07 6:25
MattPenner2-Nov-07 6:25 
OK, I love to learn new and better ways to do things, but this just doesn't seem one of them.

I'm originally from the Java camp so I've used straight DB code such as hard coded calls to the database and ORM tools like Hibernate. I've been working in VB for the past 5 years on various projects and have used similar techniques here as well.

I am working on a fairly large project and decided to use strongly typed db access such as what is taught in these fairly popular tutorials:
http://www.asp.net/learn/data-access/[^]

Boy am I getting a headache. It seems to me that the only benefits I get are IntelliSense and compile time checking. IntelliSense wasn't available before strongly typed database code so this is more of a convenience than any real need. Compile time checking is nice but I've already had several errors that are not caught until runtime. These errors largely deal with enforcing constraints when filling a DataTable using a standard DataAdapter. Most of these errors are extremely trivial, do not interfere with my actual code and would never have been brought to my attention without strongly typed db code.

So here is what I see as the major negative. I feel like I am getting much more code dependence rather than the current shift towards independence. This project largely works with data from a vendor database. If they ever update their schema (which can be as often as once a week) my app will break, even if they simply change a field from varchar(10) to varchar(12).

I'm starting to lean towards either rolling my own db code or using NHibernate again. Also, LINQ seems to be a departure from this strategy as well.

Does anyone else have any comments? Have any of you used strongly typed db code on a large project and found it to be indispensable? What am I missing?

Thanks!

Matt Penner


-- modified at 17:13 Tuesday 6th November, 2007
QuestionWork in Emulator, not work on Device Pin
Hurricane30002-Nov-07 6:25
Hurricane30002-Nov-07 6:25 
AnswerRe: Work in Emulator, not work on Device Pin
Hurricane30003-Nov-07 8:30
Hurricane30003-Nov-07 8:30 
QuestionXP Visual Style and Themes on windows forms Pin
Julius++2-Nov-07 3:27
Julius++2-Nov-07 3:27 
AnswerRe: XP Visual Style and Themes on windows forms Pin
nishkarsh_k2-Nov-07 6:43
nishkarsh_k2-Nov-07 6:43 
Questionprinting a bit thinner line... [modified] Pin
BooleanTrue2-Nov-07 3:03
professionalBooleanTrue2-Nov-07 3:03 
AnswerRe: printing a bit thinner line... Pin
BrokenS2-Nov-07 11:41
BrokenS2-Nov-07 11:41 
GeneralRe: printing a bit thinner line... Pin
BooleanTrue2-Nov-07 13:22
professionalBooleanTrue2-Nov-07 13:22 
GeneralRe: printing a bit thinner line... Pin
Luc Pattyn2-Nov-07 14:20
sitebuilderLuc Pattyn2-Nov-07 14:20 
QuestionOracle Connection fires error as: Database logon failed Pin
Venkatesh Mookkan2-Nov-07 1:40
Venkatesh Mookkan2-Nov-07 1:40 
Questiondatatable to arraylist(avoid duplicate records binding)..., Pin
Member 38798812-Nov-07 0:19
Member 38798812-Nov-07 0:19 
GeneralSecurity code for your registration or login pages pages Pin
Mohammad Mahdi Ramezanpour2-Nov-07 0:09
Mohammad Mahdi Ramezanpour2-Nov-07 0:09 
GeneralRe: Security code for your registration or login pages pages Pin
Dave Kreskowiak28-Nov-07 17:00
mveDave Kreskowiak28-Nov-07 17:00 
QuestionMS WORD Pin
alwinSCH2-Nov-07 0:06
alwinSCH2-Nov-07 0:06 
QuestionRegarding parallel port interfacing and inpout32.dll Pin
Pulkit joshi1-Nov-07 23:20
Pulkit joshi1-Nov-07 23:20 
AnswerRe: Regarding parallel port interfacing and inpout32.dll Pin
Christian Graus2-Nov-07 1:10
protectorChristian Graus2-Nov-07 1:10 
QuestionMerging DataSet = NullRefException ? [modified] Pin
galadrian1-Nov-07 22:20
galadrian1-Nov-07 22:20 
QuestionCall Stack in VB6 Pin
Nitin19811-Nov-07 20:54
Nitin19811-Nov-07 20:54 

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.