Execute Command and Now()

DataContext.ExecuteCommand("DELETE from Table WHERE Date < Now()");

I get an error about how Now() is not a recogn开发者_如何转开发ized built in function name.

When you send your SQL query directly to SQL Server, you need to use the SQL Server functions - not the .NET ones.

Use this instead:

DataContext.ExecuteCommand("DELETE from Table WHERE Date < GETDATE()");

GETDATE() is the T-SQL equivalent for Now()

Now() is not TSQL. Use GETDATE() or GETUTCDATE()

Could that be GetDate() instead of Now()?

You should use GETDATE() instead of NOW()

I don't think Now() is a recognized function in SQL.