MTS & VB

[efrat]

Hi all
what is state less?
if i develope with store procedure
its a pure middle -tier?

wfrat

[Clunietp]

Hello Efrat!

A stateless component is one that only contains functions or subs, not any properties.

The advantage of using stateless components in an MTS application is that because your objects do not have any properties (state), MTS does not have to retain any object information between calls from your client, so the object can be destroyed as soon as a function/sub has been executed. Because the object is immediately destroyed, there is no additional overhead on the server to retain that instance of the component in memory.

What do you mean by "pure" middle tier?

Lehitraot!

Tom

[Clunietp]

Shalom Efrat! I found some useful links for you:

http://msdn.microsoft.com/training/f...mwd9800581.htm

http://msdn.microsoft.com/library/pa...ldingstate.htm

A more insightful view
http://msdn.microsoft.com/library/pe...tincts1299.htm

[efrat]

Pure its meen .

If I use Store procedure and not sql query like select..
Where will be the Data Layer ?

Lehitraot Haver Yakar

Efrat

[Clunietp]

The data access layer does not have to issue a SELECT statement to be considered the data access layer.

The data access layer has all database specific code in it. It will connect to the DB, then get a recordset, perform an update, execute a stored procedure, or anything else.

The point of the data access layer is that if you were to change databases, you would only have to change your data access layer component (and NOT your business objects). You would then, however, have to rewrite your stored procedures for that DBMS, or if you use plain SQL in your data access layer, you would have to slightly modify it, but to a lesser extent.

I use stored procedures because my database will not likely change, and I get the performance benefits as well...