EF 4.1 code-first adding a trigger to a table

What is the best way to add a trigger to a table created by code-first approach with EF 4.1?

A way I'm cosidering is to execute a custom SQL query either in OnModelCreating or when Db context is being initialized.

Is there a better idea?