SQL MObile

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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?
Click to expand...

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

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

Cheers!
 
Dans : davebythesea disait :
Hi Jesse,

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

worse, IMO : no batches commands with SqlCeCommand and no output
parameters.
 
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.
 
Back
Top