Why not use MSDE all you'll need is a different connection string and its free :-)
-----Original Message----- From: Murphy, James [mailto:[EMAIL PROTECTED]] Sent: 06 June 2002 22:49 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Using DataSets as an IMDB You could do what you were thinking originally buy using the XmlDataDocument class. This class works with DataSets to allow you to work in relational and xml models at the same time. And you can run XPath queries against the data in your DataSet! Cool. Jim > -----Original Message----- > From: Dean Cleaver [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 06, 2002 5:51 PM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] Using DataSets as an IMDB > > > Means I have to have 2 different database access methods, although I > guess that's not so bad now - have to get out of the COM mindset and > think assemblies... > > Thanx for the heads up - might well be the best option. > > Dino > > -----Original Message----- > From: The DOTNET list will be retired 7/1/02 > [mailto:[EMAIL PROTECTED]] On Behalf Of Brad Wilson > Sent: Friday, 7 June 2002 09:49 > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] Using DataSets as an IMDB > > > Dean Cleaver wrote: > > > I have a project that the client wants to be able to operate in a > > corporate environment with many users on SQL Server, and also in a > > standalone environment (I don't mean these users working offline, I > > mean a "1 user site") without SQL Server. > > > One thought I had was to create XML files for all the data, and then > > load them one by one into a DataSet and then add the > foreign keys etc > > to effectively create an IMDB - but does that allow me to select out > > based on a query or anything? Can I select a "view" based > on a couple > > of data tables in a dataset? > > Why not Jet (Access .mdb file)? > > Brad > > -- > Read my web log at http://www.quality.nu/dotnetguy/ > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, > or subscribe to other DevelopMentor lists at > http://discuss.develop.com. > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.370 / Virus Database: 205 - Release Date: 05/06/2002 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.370 / Virus Database: 205 - Release Date: 05/06/2002 > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or > subscribe to other DevelopMentor lists at http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.