KunalS[MS]: Hello All and thank you for joining into the VBDotNetIndia Chat

KunalS[MS]: Today's topic is

KunalS[MS]: ADO .NET and Data Mgmt in .NET Framework

KunalS[MS]: We have from MS Shanghai

Canton: where can we find info for programming in ASP.NET ?

KunalS[MS]: Peter Wu, Robin Shen and Shi Gao joining us

KunalS[MS]: You may ask them all the questions you have about managing data in VB .NET

Peter[MS]: You can find information on ASP.NET at http://www.asp.net

Canton: Ok...thanks...

Robin[MS]: hi, nice to meet u all

Peter[MS]: Hello!

Canton: How do we employ XML in an ASP / SQL Server architecture ?

Canton: i mean asp.net / sql server architecture ...

Peter[MS]: Canton, can you please be more specific?

Canton: Ok...

Canton: I really want to use XML on our B2B platform...

Canton: currently it's running on ASP & SQL SERVER

Canton: But, movING to ASP.NET / SQL SERVER 2000 next week...

Gurneet: hi gurneet here

Peter[MS]: I guess you need to involve BizTalk Server for your B2B architecture

Canton: Oh...

Peter[MS]: Today, we're focusing on ADO.NET w/ VB.NET.

Robin[MS]: You can ask questions while you migrate to ADO.NET from ADO

Ajay: If I may ask now, There was this question a couple of days back on this list about using Data Shape with ADO.Net to improve

sagarmcp: can we use ado.net with vb6.

Ajay: the performance

Peter[MS]: Yes.

Ajay: what so you suggest

Ajay: is Data Shape the way to go

Peter[MS]: You can use ADO.NET in VB6.

Peter[MS]: You can use com interop to realize this functionality.

sagarmcp: interop??

SSPandian: Hi. In Vb 6.0 Data Reports and Data Environments are available. Will there be any change in Vb.NET??

Peter[MS]: Yes. Interop technology that enables you use managed code from unmanaged world and vice versa.

Peter[MS]: However, this is not what Microsoft recommends in VB6.

Peter[MS]: But, you CAN do it in VB6.0. It's technically possible.

Robin[MS]: SSPandian, in VB.NET we don't have data report

Robin[MS]: Instead it ship CrystalReport

Gurneet: I would like to know what are disadvatages of ADo.NET

Gurneet: are there any???

Robin[MS]: Oh, yeah Kunal, while migrate from ADO to ADO .Net we have some articles on MSDN like http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/adonetprogmsdn.asp

Peter[MS]: In ADO.NET, we use disconnected modal other than the connected model in the legacy ADO.

Peter[MS]: However, you can continue to use DataReader to use the Connected feature.

Peter[MS]: In ADO.NET, you can have a DataSet, which is considered an in-memory database.

Gurneet: Peter what exactly do you mean by disconnected here

Peter[MS]: OK.

Gurneet: In ADO also we had disconnected recordsets

Peter[MS]: Disconnected model means that after the data has been retrieved from the underlying data source, the connection is useless.

Peter[MS]: We do not need the connection

Peter[MS]: In old ADO, we have disconnectedd recordsets.

Peter[MS]: But ADO was designed mainly for connected model.

Gurneet: So isnt it same that we can get the data into a recordset and discoonect

Gurneet: work on it and then fire our all updates or whatever after making a connection

Peter[MS]: Therefore, disconnectd feature is not working very well in legacy ado.

Peter[MS]: They're different.

Gurneet: how is it different in architecture now

Peter[MS]: In a disconnected recordset, it is a recordset.

Gurneet: ok

Peter[MS]: A recordset can ONLY contain 1 table, or a JOIN'd table.

Gurneet: true

Gurneet: i got it

Ajay: Has there been any major changes in ADO.Net since Beta 2 due to which I will have to make changes my code written in Beta 2?

Peter[MS]: However, DataSet can have many DataTables and they can be managed without the connection.

Robin[MS]: ADO .NET architecture at http://msdn.microsoft.com/library/en-us/cpguide/html/cpconadonetarchitecture.asp

Gurneet: thanks for reference

Gurneet: ok peter what are the migration issue that one will encounter from ADO to ADO.NET

Gurneet: I mean we have amigration tool but does it take care of most of things

Peter[MS]: Most probably, you will switch to the new model of ado.net

Peter[MS]: It's a significant change, I think.

Gurneet: so does migration tool help in poritng my application written in ADO to ADO.NET

Gurneet: i mean VB 6 to VB.NET

Peter[MS]: Yes. It will help.

Peter[MS]: yes. We have a tool helping migrate from VB6 to VB.NET.

Peter[MS]: However, the tool has some limitations.

Peter[MS]: NOT all the legacy VB6 applications can be smoothly migrated to VB.NET.

Peter[MS]: Such as some with 3rd party controls.

Gurneet: ok

kunal: Hi Peter & Robin

sagarmcp: can all activex controls developed for vb 6 work on .net?

Peter[MS]: Hi Kunal

sagarmcp: or i have to recompile them for vb.net?

Peter[MS]: Basically, ActiveX controls can be used in .NET with interop technology

kunal: Peter---> Well the Design of ADO.Net Looks a tough to migrate to

Peter[MS]: The migration may be tough because of the significant design change.

sagarmcp: Peter can you explain avout Interop technology ?

Peter[MS]: Since the data is retrieved in a client memory, a 2nd access to the data will be faster!

Peter[MS]: Well, today's topic is about ADO.NET and VB.NET.

Madhu: How can u develop a generic data access layer using ADO.NET?

Gurneet: Peter what about XML integration with ADO.NET

ilyd: Can I use legancy ADO in .NET? It seems there is no server side cursor in ado.net

Peter[MS]: Interop is a technology that enables managed world and unmanaged world talk to each other.

Robin[MS]: Ajay, generall speaking there is not significant design change from Beta2 to RTM.

santu: i have a database aplication in VB6 using ADO & if i want to upgrade it to VB.NEt, whats the shortcut so that the application remains unaffected

Peter[MS]: Yes, you can inherit from DataAdapter class.

Ajay: so

Ajay: my code would work

Ajay: as it is (from Beta 2)?

Madhu: Peter, How can you develop a generic Data Access Layer using ADO.NET?

Ajay: when compiled with Version 1

Robin[MS]: But you'd better test against RTM version as there maybe many issues involved while develop in VS.NET

Ajay: okay. Thanks

Peter[MS]: Yes, you can inherit from DataAdapter class.

Madhu: So, you mean to say my DAL should inherit from the data adapter class???

Peter[MS]: re: the migration of vb6 ado application

Gurneet: Peter are there any changes to ADO.NET architecture from Beta 2 to Final Release

kunal: Peter--> just for Getting the current row Position, lot of coding is required?

Peter[MS]: You can try the vb.net migration.