Moving from Embedded DB2 to Visual Studio 2005

Question

Hi everybody there,

I would like to find out {

Moving from IBM DB2 embedded SQL to Visual Studio 2005 professional
{

Is it possible to use embedded SQL as in VAGEN SmallTalk ... namely straight SQL statements in the code?

OR

Should I use DAL instead and put these statemnts in the DAL adapters?

OR

Should I use dynamic SQL with system.data.sqlclient.xxx statemnts

OR

maybe the last two...

I am pondering on the first embedded approach because of duration concerns (not mine|:-)

I will specially appreciate ASAP responses but 'all will be welcome.

Kind regards.

Ali R+ SARAL