473,320 Members | 1,884 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Data Component, Data Layer

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

Jan 4 '07 #1
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.

Jan 4 '07 #2

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

Jan 4 '07 #3
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 -
Jan 4 '07 #4

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 -
>

Jan 4 '07 #5
"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...
Jan 4 '07 #6
//
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...


Jan 5 '07 #7
"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!
Jan 5 '07 #8
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!
Jan 7 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
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...
0
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...
5
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...
2
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...
13
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...
0
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...
3
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...
2
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...
9
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...
0
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...
0
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...
0
isladogs
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...
1
isladogs
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...
0
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...
1
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.