get rid of MTS

[stm]

Hi all,

We are moving from VB to .NET soon. In existing design, VB client interact with backend through a MTS COM.

The purpose of this COM is to
- check if the logon user have access right to the system by passing in the NT login ID.
- execute sql statement on behalf of the client and return a recordset to client by passing in the sql statement

I understand that .NET still support COM/COM+, but need to pass through RCW, so there is a performance hit.
Another problem is that the existing DCOM return ADO recordset only, which is not compatiable with ADO.NET, and I think it will be another performance issue.

So can anyone suggest some good solution for migrating to .NET for our situation?

Thx!!

[spoiledkid]

I think you can still use old style ADO in .NET by using InterOpServices and referecing to old Ado Library.

[stm]

Hi,

I afraid it will be slower, and can't make use of ADO.NET features?!

Thx!