MBR IT/.NET 247 : What data structure/objects to usde on ASPFriends.com 'aspngmigrate' list

What data structure/objects to usde

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngmigrate' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Bill Bassler

-- Copied from [aspngarchitecture] to [aspngmigrate] by Tony Stark <Click here to reveal e-mail address> --

The problem:
I have a VB 6.0/ASP app that I'd like to convert to .Net.
The app essentially pulls and combines event data from several sources.
The resulting data is sortable by time order and can be filtered by date and
or time.
Currently it uses a database table and SQL to collect, sort and filter the
events. When a run is complete, the table is disposed of.

The goal:
Ideally, I would like to do away the use of a database table as an
intermediate store to process the events. I've had to write a decent amount
of code just to attempt to clean the table up in the event of an error.
Database or otherwise. Also, SQL(#) temp tables will not work as this is a
web app with many short duration connections.

Ideas?
I was wondering if I could use something like an in memory XML DOM to store,
sort and filter event info... or is there a better choice to replace the
database table? Is there another .Net data object that is well suited to
this purpose?

The question
1 .Does this make sense.
2. Can I keep this object(s) completely in memory. To me, using an XML file
defeats the purpose.
3. Can I easily get the fine-grained time filtering and time sorting
functionality of SQL statements using (I guess XSL to HTML) conversion.
4. How robust will this approach be.
5. Anyone have a better idea.

Reply to this message...

Marcie Jones (VIP)

Hi Bill,
It sounds very do-able to me, I would recommend using
an Ado.Net DataSet for this. It is basically an
in-memory XML-based representation of the data, it
should be exactly what you're looking for.

To answer your questions:

> 1 .Does this make sense.
Yes.

[Original message clipped]

[Original message clipped]

the DataTables in a DataSet, or you can easily convert
it to XML and do XSLT type stuff on it.

> 4. How robust will this approach be.
Seems to be very robust to me.

> 5. Anyone have a better idea.
Nope :)

Good luck!
Marcie

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Reply to this message...

System.Data.DataSet

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com