Doing delete gives me error

ServiceStack.OrmLite
1

Hi,
i’m using ORMLite and Sql Server.
When i do a select and then trying to delete the object i get this error .

Any idea?

{System.Data.SqlClient.SqlError: The data types time and datetime are incompatible in the equal to operator.}

Here is my code

var servicePrice = Db.LoadSelect<ServiceModel.Db.ServicePrice>(
               Db.From<ServiceModel.Db.ServicePrice>()
            .Where(s => s.CompanyId == request.CompanyId && s.Id == request.Id)).FirstOrDefault();

        Db.DeleteAll(servicePrice.DayOfWeeks);
        Db.Delete(servicePrice);
2

It’s not possible to identify the issue with just what’s provided, except that you’re doing something that’s not supported. You need to include the full StackTrace which shows exactly which line of code causes the Exception as it’s impossible to determine from here.

DeleteAll<T> should use a generic Type of the table you want to delete all rows of which isn’t shown in your example.