SQL MObile

[Guest]

Hi Folks,

Is it possible to write triggers for SQL Mobile? I'm using VS2005. I was
hoping the DataSet designer may allow triggers to be developed? Or is there
some other way to write triggers?

Thanks very much for any tips,

Cheers!

 

[Jesse Houwing]

Hello davebythesea,

Hi Folks,

Is it possible to write triggers for SQL Mobile? I'm using VS2005. I
was hoping the DataSet designer may allow triggers to be developed? Or
is there some other way to write triggers?

Sql Mobile or Sql Compact Edition do not support Triggers, Stored Procedures
or any other fancy programming features. It is a database at heart.

 

[Guest]

Hi Jesse,

Thanks for the answer. So no triggers or stored procedures ;-( Ok cool.

Cheers!

 

[Fred]

Dans : davebythesea disait :

Hi Jesse,

Thanks for the answer. So no triggers or stored procedures ;-( Ok
cool.

worse, IMO : no batches commands with SqlCeCommand and no output
parameters.

 

[Guest]

The next best thing to Stored Procedures is to use paramerterized queries
coupled with the DataReader class for performance reasons.

In terms of triggers not being supported in Microsoft SQL Mobile, you'll
need to write your BLL/DAL to emulate this. Subscribe and raise events when
some event occurs.

 

[Guest]

Hi Simon,

Thanks for your answer. Very helpful.

Cheers,
David