I am developing couple intranet site. Cant decide what to use to get
the Data
I will be using Data Layer to get,update, insert, delete and report
type queries..
Most expensive table will have 1 mil records.. Just a couple of tables
will have that amount of data..
What would be affecient to use between
1. Code behind to call SqlDataAdapter,SqlConnection,SqlCommand,DataSet
etc
2. Table Adapters with DataSet connected to Database
3. Own Writen Data.cs like dataComponent somesort..
4. Enterprise Library January 2006, Application Data Block 8 1840
Matt wrote:
I am developing couple intranet site. Cant decide what to use to get
the Data
I will be using Data Layer to get,update, insert, delete and report
type queries..
Most expensive table will have 1 mil records.. Just a couple of tables
will have that amount of data..
What would be affecient to use between
1. Code behind to call SqlDataAdapter,SqlConnection,SqlCommand,DataSet
etc
2. Table Adapters with DataSet connected to Database
3. Own Writen Data.cs like dataComponent somesort..
4. Enterprise Library January 2006, Application Data Block
If you are doing the modification on huge records, then #1 is the
better, if you are using the data only for display purpose then #3.
See
5/24/2006
Custom Objects/Collections and Tiered Development
6/5/2006
Custom Objects and Tiered Development II // 2.0
at: http://sholliday.spaces.live.com/blog/
You can substitute the EnterpriseLibrary block where I have the SqlHelper
class.
The examples show how to write your own data layer, using SqlHelper (or
EnterpriseLibrary ) as the ~~~helper class.
"Matt" <me*******@Hotmail.comwrote in message
news:11*********************@v33g2000cwv.googlegro ups.com...
I am developing couple intranet site. Cant decide what to use to get
the Data
I will be using Data Layer to get,update, insert, delete and report
type queries..
Most expensive table will have 1 mil records.. Just a couple of tables
will have that amount of data..
What would be affecient to use between
1. Code behind to call SqlDataAdapter,SqlConnection,SqlCommand,DataSet
etc
2. Table Adapters with DataSet connected to Database
3. Own Writen Data.cs like dataComponent somesort..
4. Enterprise Library January 2006, Application Data Block
Any other thought code behind vs Blocks vs Component modelize cs..
Pros and Cons ?
Thanks
On Jan 4, 10:53 am, "sloan" <s...@ipass.netwrote:
See
5/24/2006
Custom Objects/Collections and Tiered Development
6/5/2006
Custom Objects and Tiered Development II // 2.0
at:
http://sholliday.spaces.live.com/blog/
You can substitute the EnterpriseLibrary block where I have the SqlHelper
class.
The examples show how to write your own data layer, using SqlHelper (or
EnterpriseLibrary ) as the ~~~helper class.
"Matt" <meteha...@Hotmail.comwrote in messagenews:11*********************@v33g2000cwv.go oglegroups.com...
I am developing couple intranet site. Cant decide what to use to get
the Data
I will be using Data Layer to get,update, insert, delete and report
type queries..
Most expensive table will have 1 mil records.. Just a couple of tables
will have that amount of data..
What would be affecient to use between
1. Code behind to call SqlDataAdapter,SqlConnection,SqlCommand,DataSet
etc
2. Table Adapters with DataSet connected to Database
3. Own Writen Data.cs like dataComponent somesort..
4. Enterprise Library January 2006, Application Data Block- Hide quoted text -- Show quoted text -
There is a difference between rapid development and good development.
I side on good development, not rapid development.
The new "built in" stuff with the aspx code behind for database connectivity
is "rapid' in my book.
Fine for demo's or prototypes, not good for a software solution.
If you create a DataLayer object, and that object uses SqlHelper or
EnterpriseLibrary to "help" with data access, you're building a reusable
component, and its much easier to maintain.
In my sample, I think I have something like
OrderData
or
CustomerData
classes.
As the blog states, this returns IDataReaders, DataSets , scalars or voids.
The downloadable code is sitting there to learn from. The better you
architect up front, the more time you'll save in the long run.
"Matt" <me*******@Hotmail.comwrote in message
news:11**********************@6g2000cwy.googlegrou ps.com...
Any other thought code behind vs Blocks vs Component modelize cs..
Pros and Cons ?
Thanks
On Jan 4, 10:53 am, "sloan" <s...@ipass.netwrote:
See
5/24/2006
Custom Objects/Collections and Tiered Development
6/5/2006
Custom Objects and Tiered Development II // 2.0
at: http://sholliday.spaces.live.com/blog/
You can substitute the EnterpriseLibrary block where I have the
SqlHelper
class.
The examples show how to write your own data layer, using SqlHelper (or
EnterpriseLibrary ) as the ~~~helper class.
"Matt" <meteha...@Hotmail.comwrote in
messagenews:11*********************@v33g2000cwv.go oglegroups.com...
I am developing couple intranet site. Cant decide what to use to get
the Data
I will be using Data Layer to get,update, insert, delete and report
type queries..
Most expensive table will have 1 mil records.. Just a couple of tables
will have that amount of data..
What would be affecient to use between
1. Code behind to call SqlDataAdapter,SqlConnection,SqlCommand,DataSet
etc
2. Table Adapters with DataSet connected to Database
3. Own Writen Data.cs like dataComponent somesort..
4. Enterprise Library January 2006, Application Data Block- Hide
quoted text -- Show quoted text -
>
"sloan" <sl***@ipass.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
The new "built in" stuff with the aspx code behind for database
connectivity
is "rapid' in my book.
Fine for demo's or prototypes, not good for a software solution.
In fact I would venture to say that, when compared to a decent DAL, the new
SqlDataSource stuf is actually *slower* to develop with...
"New" doesn't always mean "better", IMO...
An example of this is the CustomValidator stuff - I've never found anything
in that that I couldn't do quicker and easier with my own JavaScript
validation scripts...
//
In fact I would venture to say that, when compared to a decent DAL, the new
SqlDataSource stuf is actually *slower* to develop with...
"New" doesn't always mean "better", IMO...
//
Amen.
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:eE**************@TK2MSFTNGP02.phx.gbl...
"sloan" <sl***@ipass.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
The new "built in" stuff with the aspx code behind for database
connectivity
is "rapid' in my book.
Fine for demo's or prototypes, not good for a software solution.
In fact I would venture to say that, when compared to a decent DAL, the
new
SqlDataSource stuf is actually *slower* to develop with...
"New" doesn't always mean "better", IMO...
An example of this is the CustomValidator stuff - I've never found
anything
in that that I couldn't do quicker and easier with my own JavaScript
validation scripts...
"sloan" <sl***@ipass.netwrote in message
news:eU**************@TK2MSFTNGP02.phx.gbl...
In fact I would venture to say that, when compared to a decent DAL, the
new
SqlDataSource stuf is actually *slower* to develop with...
"New" doesn't always mean "better", IMO...
I couldn't agree more!
Thanks for all the input
Mark Rae wrote:
"sloan" <sl***@ipass.netwrote in message
news:eU**************@TK2MSFTNGP02.phx.gbl...
In fact I would venture to say that, when compared to a decent DAL, the
new
SqlDataSource stuf is actually *slower* to develop with...
"New" doesn't always mean "better", IMO...
I couldn't agree more!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Angelos Karantzalis |
last post by:
Hi guys,
for a while now, we've been flirting with the idea of having a single
component in our app that handles all the plumbing for our Db calls (
creating connections, Commands & Parametes...
|
by: Steven Kilby |
last post by:
I have a component (inproc dll) written in VB6. I have a client written in
C#. If I compile the component to native code everything works fine. I add
the necessary type library for my component...
|
by: jqpdev |
last post by:
Hello all...
I'm coming from a Borland Delphi background. Delphi has a specific
component called a Data Module. In the designer the Data Module behaves
like a windows form. A developer can...
|
by: headware |
last post by:
I'm relatively new to ASP.NET and ADO.NET, but I have a basic design
question regarding the use of web services and APS.NET applications.
Right now we have an application that uses web services to...
|
by: Michelle |
last post by:
Hi all... I could use a little TLC here for understanding and not for
solving a specific problem... sorry if I've got the wrong group, but I'm
using VB so I figured this was the most appropriate...
|
by: as_lev |
last post by:
Hello!
First, I want to reccomend the Fantasticthe article about distributed
applications
http://msdn.microsoft.com/architecture/default.aspx?pull=/library/en-us/dnbda/html/BOAGag.asp
I am...
|
by: Mark Gilkes |
last post by:
I would just like to get a feeling for what others are doing here. Having
read through the 'Data Tiers' paper under MS's Paterns and Practices I am
designing and developing a small(ish) 3 layered...
|
by: grawsha2000 |
last post by:
Greetings,
I am developing this N-tier business app. The problem I'm facing is
when I try to pass business objects (employees, dept..etc) from
business tier to data tier,i.e., the add method in...
|
by: SAL |
last post by:
Hello,
I have a Dataset that I have table adapters in I designed using the designer
(DataLayer). I have a business logic layer that immulates the DataLayer
which may/may not have additional logic...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| | |