Himanshu there are another 2 ways in addition to the 2 that you mention - that is XML and Soap/Web Services
Soap/Web Services is my preferred way as you get a self describing (via the WSDL) typed native object in .Net to expand the problem with Factory is that the .Net side has to know about the internals of the database the problem with SQL is that it's not an object structure whereas SOAP provides a rich quasi object structure that in instantated on the .Net as a native .Net object and vica verse It's also more loosly connected than Factory or ADO.Net Peter On Wed, 18 Aug 2004 01:56:52 +1000, "Himanshu" <[EMAIL PROTECTED]> wrote: >Hi, > >I've just started using Cache from Visual Studio 2003 .NET and found two >ways >- Using COM/ActiveX >- Using ADO .NET > >Is using one or the other better? Using COM/ActiveX method..... I still had >to use factory.DynamicSQL to run the query. > >And in ADO. NET I would be using an SQL query too. > >So just how does one make use of the 'Object' features using COM/ActiveX? Is >there some other way of retrieving data from tables other than >factory.DynamicSQL? >Or do I have to use ADO .NET to get objects? > >Sorry but I was getting a bit lost in that part. > >Thanks in advance > >Regards, > >Himanshu > >P.S. I'm using C# during all this >
