SQL Server - nhibernate y sqlserver

I´ve got the following query. this query works for SQL SERVER 2000 Spanish but not for English.

ses.CreateSQLQuery("delete from rol_usuariotecnico where idRol=" + rol.IdRol + " AND idUsuario='"+ rol.Usuario.Id + "' AND fechaIni= '" + rol.FechaIni + "' AND fechaFin='" + rol.FechaFin + "'", "borrarRoles", typeof(Incidencia)).List();

The problem is with the format of th dates. How can i solve it?

Borja

This it is a forum in Spanish, tries to use format ANSI, like this

YYYY-MM-DD

Regards

El problema es no usar querys parametrizadas. COn eso se soluciona el problema