Do you prefer writing your DAL code by hand, or do you like to use the
graphical interface of creating XSD datasets in Visual Studio 2008?
What do you feel are the pros/cons?
I hope this makes sense...
6  1687 
If the project is going to last more than 6 months, then hand coding.
...
However, when creating a strongly typed data set, I still use the GUI.
Right Click, Add Table.
Right Click, Add Column.
I just don't wire up table adapters.
....................
I actually like the 1.1 days better when I could see the xml, and make edits
there.
Yes, I could do it in notepad...but I like the 1.1 days of this specific
thing.
(Don't get me wrong, that's a drop in the bucket compared to everything you
get in 2.0 and up).
........................
........................
RAPID != Good. I find the maintenance aspect much easier to deal with when
I avoid the MS Voodoo of dragging tables into datasets, etc, etc.
"Cirene" <ci****@nowhere.comwrote in message
news:eJ**************@TK2MSFTNGP06.phx.gbl...
Do you prefer writing your DAL code by hand, or do you like to use the
graphical interface of creating XSD datasets in Visual Studio 2008?
What do you feel are the pros/cons?
I hope this makes sense...
"sloan" <sl***@ipass.netwrote in message
news:u4**************@TK2MSFTNGP04.phx.gbl...
>
If the project is going to last more than 6 months, then hand coding.
So, for bigger projects that you will have to maintain you like to hand code
the DAL, to call the stored procs, etc...?
>
However, when creating a strongly typed data set, I still use the GUI.
Right Click, Add Table.
Right Click, Add Column.
I just don't wire up table adapters.
Is this in the case where you want to use disconnected data?
>
RAPID != Good. I find the maintenance aspect much easier to deal with
when I avoid the MS Voodoo of dragging tables into datasets, etc, etc.
MS Voodoo = LOL
Except for reports (where I use strong datasets mainly), I use custom
objects and custom business collections 98% of the time now.
For strong datasets, I use the EnterpriseLibrary.Data "LoadDataSet" method.
.......
For custom business objects/collections, I use IDataReaders and either
single or multiple resultsets coming back from Sql Server (2000,2005).
.......
Here is a sampling:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!158.entry
If you go to: http://sholliday.spaces.live.com/Blog/
I have a "Custom Business Objects" version 2.0 and original version (1.1).
..........
//Is this in the case where you want to use disconnected data?//
Mainly strong datasets.
I use custom business objects and collections...and use optimisitic
(timestamp/rowversion) stuff when concurrency is an issue.
...............
"Cirene" <ci****@nowhere.comwrote in message
news:Oe**************@TK2MSFTNGP02.phx.gbl...
"sloan" <sl***@ipass.netwrote in message
news:u4**************@TK2MSFTNGP04.phx.gbl...
>>
If the project is going to last more than 6 months, then hand coding.
So, for bigger projects that you will have to maintain you like to hand
code the DAL, to call the stored procs, etc...?
>>
However, when creating a strongly typed data set, I still use the GUI.
Right Click, Add Table.
Right Click, Add Column.
I just don't wire up table adapters.
Is this in the case where you want to use disconnected data?
>>
RAPID != Good. I find the maintenance aspect much easier to deal with
when I avoid the MS Voodoo of dragging tables into datasets, etc, etc.
MS Voodoo = LOL
In theory there should be NO SQL statements or stored procedure names in the
Business Object tier, correct? It should only be in the DAL????
I'm trying to learn the "right" way to do it...
"sloan" <sl***@ipass.netwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
Except for reports (where I use strong datasets mainly), I use custom
objects and custom business collections 98% of the time now.
For strong datasets, I use the EnterpriseLibrary.Data "LoadDataSet"
method.
......
For custom business objects/collections, I use IDataReaders and either
single or multiple resultsets coming back from Sql Server (2000,2005).
......
Here is a sampling:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!158.entry
If you go to:
http://sholliday.spaces.live.com/Blog/
I have a "Custom Business Objects" version 2.0 and original version (1.1).
.........
//Is this in the case where you want to use disconnected data?//
Mainly strong datasets.
I use custom business objects and collections...and use optimisitic
(timestamp/rowversion) stuff when concurrency is an issue.
..............
"Cirene" <ci****@nowhere.comwrote in message
news:Oe**************@TK2MSFTNGP02.phx.gbl...
>"sloan" <sl***@ipass.netwrote in message
news:u4**************@TK2MSFTNGP04.phx.gbl...
>>>
If the project is going to last more than 6 months, then hand coding.
So, for bigger projects that you will have to maintain you like to hand
code the DAL, to call the stored procs, etc...?
>>>
However, when creating a strongly typed data set, I still use the GUI.
Right Click, Add Table.
Right Click, Add Column.
I just don't wire up table adapters.
Is this in the case where you want to use disconnected data?
>>>
RAPID != Good. I find the maintenance aspect much easier to deal with
when I avoid the MS Voodoo of dragging tables into datasets, etc, etc.
MS Voodoo = LOL
On Sep 12, 12:45*pm, "Cirene" <cir...@nowhere.comwrote:
In theory there should be NO SQL statements or stored procedure names in the
Business Object tier, correct? *It should only be in the DAL????
I'm trying to learn the "right" way to do it...
"sloan" <sl...@ipass.netwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
Except for reports (where I use strong datasets mainly), I use custom
objects and custom business collections 98% of the time now.
For strong datasets, I use the EnterpriseLibrary.Data "LoadDataSet"
method.
......
For custom business objects/collections, I use IDataReaders and either
single or multiple resultsets coming back from Sql Server (2000,2005).
......
Here is a sampling:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!158.entry
If you go to:
http://sholliday.spaces.live.com/Blog/
I have a "Custom Business Objects" version 2.0 and original version (1.1).
.........
//Is this in the case where you want to use disconnected data?//
Mainly strong datasets.
I use custom business objects and collections...and use optimisitic
(timestamp/rowversion) stuff when concurrency is an issue.
..............
"Cirene" <cir...@nowhere.comwrote in message
news:Oe**************@TK2MSFTNGP02.phx.gbl...
"sloan" <sl...@ipass.netwrote in message
news:u4**************@TK2MSFTNGP04.phx.gbl...
>If the project is going to last more than 6 months, then hand coding.
So, for bigger projects that you will have to maintain you like to hand
code the DAL, to call the stored procs, etc...?
>However, when creating a strongly typed data set, I still use the GUI..
Right Click, Add Table.
Right Click, Add Column.
>I just don't wire up table adapters.
Is this in the case where you want to use disconnected data?
>RAPID != Good. *I find the maintenance aspect much easier to dealwith
when I avoid the MS Voodoo of dragging tables into datasets, etc, etc..
MS Voodoo = LOL
Well, I going to have to plug my favorite product here. I've been
using LLBLGen Pro for years now and love it. I have no affiliation
with the company in any way, I just think it's best product I've used
to date for the money.
Does LLBLGen Pro create the stored procedures for you? Does it work well
with MySQL and Visual Studio.net?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bruce Stockwell |
last post by:
the setup:
Webservice/WinClient application/SQL server.
VS.Net (visual basic) winform wizard creates a simple form
with load cancel cancelall and datagrid bound to a simple
Dataset with one...
|
by: Richard A. Lowe |
last post by:
I'm new to hand-coding XSD files - how can I indicate that I want to
reference tags from another XSD document in a certain section of my
XSD? Essentially, I want to define one XSD with some...
|
by: Bruce Stockwell |
last post by:
the setup:
Webservice/WinClient application/SQL server.
VS.Net (visual basic) winform wizard creates a simple form
with load cancel cancelall and datagrid bound to a simple
Dataset with one...
|
by: m.roello |
last post by:
Hi,
Anyone can tell me how to define different custom namespaces for xsd
datasets in ASP.NET web sites
For example, Suppose to have the above folder tree in the App_Code directory
App_Code...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
