Click here to Skip to main content
15,920,111 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
General[Message Deleted] Pin
#12311-May-07 19:53
#12311-May-07 19:53 
GeneralRe: database dependencies Pin
kindd11-May-07 22:31
kindd11-May-07 22:31 
GeneralRe: database dependencies Pin
kindd13-May-07 21:30
kindd13-May-07 21:30 
GeneralRe: database dependencies Pin
kindd14-May-07 20:12
kindd14-May-07 20:12 
QuestionWindows App and Web App. Where can the two meet. Pin
BigPMcCoy8-May-07 12:02
BigPMcCoy8-May-07 12:02 
AnswerRe: Windows App and Web App. Where can the two meet. Pin
Ed.Poore8-May-07 12:05
Ed.Poore8-May-07 12:05 
AnswerRe: Windows App and Web App. Where can the two meet. Pin
led mike9-May-07 5:04
led mike9-May-07 5:04 
QuestionAsp.Net Database Usage vs Windows Application Database Usage [modified] Pin
Tristan Rhodes8-May-07 5:13
Tristan Rhodes8-May-07 5:13 
Hi Guys,

I have been working with databases in a professional enviroment for about 2 years now. Currently where i work there is a tendancy to encourage flat packed code with inline SQL. My attempt to get them to move over to datasets failed.

I regularly find myself trying to figure out exactly how a complex set of functionalty should be written, and while i use Datasets, i find them to be an irritation for a few reasons:

1) The typed Datatables don't support null types
2) The DataRows don't have a parameterless constructor.
2) I can't throw together an ad-hoc query and get a non schema checked report back.
3) They are pretty bulky.

However, they do make throwing working code together increadably fast, but they aren't the neatest solution in the world.

I also feel there must be a fundamentaly different approach when using databases between a Client based app and a web app. I don't think that a fully functional ORM would be particularly useful in a web enviroment as it's not really nescessary. Many database functions are small and singular with the exception of large scale reports.

I'm basicaly looking for something which covers the following points:

1) Lightewight DataObjects and DataAdapters (Not nescessarily .Net Standard Library)
2) Where the DataObjects have parameterless constructors.
3) Where the DataObjects support nullable types.
4) Where the DataObjects support serialization.
5) Where the DataAdapters support Transactions.
6) Where the DataAdapters Support Multi-Batch Reports (Into a collection of tables or DataObjectArrays)
7) Where the DataAdapters load DbCommand objects on demand, rather than upfront. (TableAdapters currently generate all the DbCommands on Init, even if you are only using one)
8) Some kind of integrated SQL Generator for both Stored Procs and text based SQL.

I've looked at a few ORM tools, but they seem excessively complicated for my needs.

Do people have any thoughts on this, or any pointers?

I like Code and i like Databases, but they seem to have some kind of mental compatibility issue for me.

Cheers

Tris


-- modified at 11:31 Tuesday 8th May, 2007

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

AnswerRe: Asp.Net Database Usage vs Windows Application Database Usage Pin
led mike9-May-07 4:44
led mike9-May-07 4:44 
GeneralRe: Asp.Net Database Usage vs Windows Application Database Usage Pin
Tristan Rhodes9-May-07 6:24
Tristan Rhodes9-May-07 6:24 
QuestionPlugIns - Preventing Malicious Code... Pin
Shy Agam6-May-07 1:47
Shy Agam6-May-07 1:47 
AnswerRe: PlugIns - Preventing Malicious Code... Pin
Moak16-May-07 6:55
Moak16-May-07 6:55 
Questionlibrary managment object model Pin
kaptaintens5-May-07 17:52
kaptaintens5-May-07 17:52 
GeneralRe: library managment object model Pin
kaptaintens5-May-07 19:16
kaptaintens5-May-07 19:16 
GeneralRe: library managment object model Pin
kaptaintens5-May-07 20:07
kaptaintens5-May-07 20:07 
GeneralRe: library managment object model Pin
Tristan Rhodes9-May-07 4:41
Tristan Rhodes9-May-07 4:41 
QuestionInherit without exposing? Pin
francoisdotnet4-May-07 4:47
francoisdotnet4-May-07 4:47 
AnswerRe: Inherit without exposing? Pin
CPallini4-May-07 5:07
mveCPallini4-May-07 5:07 
GeneralRe: Inherit without exposing? Pin
francoisdotnet4-May-07 5:22
francoisdotnet4-May-07 5:22 
GeneralRe: Inherit without exposing? Pin
CPallini4-May-07 5:33
mveCPallini4-May-07 5:33 
AnswerRe: Inherit without exposing? Pin
led mike4-May-07 17:08
led mike4-May-07 17:08 
GeneralRe: Inherit without exposing? Pin
Stephen Hewitt6-May-07 16:00
Stephen Hewitt6-May-07 16:00 
GeneralRe: Inherit without exposing? Pin
led mike6-May-07 16:30
led mike6-May-07 16:30 
GeneralRe: Inherit without exposing? Pin
Stephen Hewitt6-May-07 16:40
Stephen Hewitt6-May-07 16:40 
GeneralRe: Inherit without exposing? Pin
led mike6-May-07 17:01
led mike6-May-07 17:01 

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.