sql server ce - The Ntext And Image Data Types Cannot Be Used In WHERE, HAVING, GROUP BY, ON, Or IN Clauses -
I am getting an error:
not used in ntext and image data types Whereas, having, by group, by, on, or in the segment, except when trying to save the changes in the table SQLCE are when these data types are used with like or zero predicate.
Please note this is an update operation.
I have version 3.5.1.0 of SQL.
Below is a stack trace with error message and code:
System.Data.SqlServerCe.SqlCeException could not be performed without message = ntext and image data type Except, where, having, used by the group, at, or in the segment, when these data types are used with or in addition to zero predictions. Source = SQL Server Compact ADO.NET Data Provider
HRESULT = -2147217900
NativeError = 25,923
StackTrace:
System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan (low)
on System.Data .SqlServerCe.SqlCeCommand.ExecuteCommand (CommandBehavior behavior, string method, ResultSetOptions option) System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery (at
)
System.Data.Linq.SqlClient.SqlProvider.Execute (expression query , QueryInfo queryInfo, IObjectReaderFactory factory, object [] parentArgs, object [] userArgs, ICompiledSubQuery [] subquery, object LASTRESULT total)
on System.Data.Linq.SqlClient.SqlProvider.ExecuteAll (expression query, QueryInfo [] queryInfos, IObjectReaderF actory factory, [] userArguments, ICompiledSubQuery [] subquery)
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute (expression query)
in System.Data.Linq thing. ChangeDirector.StandardChangeDirector.DynamicUpdate on System.Data.Linq.ChangeDirect (TrackedObject items)
or.StandardChangeDirector.Update (TrackedObject items)
on System.Data.Linq.ChangeProcessor.SubmitChanges (ConflictMode failureMode)
System .Data.Linq.DataContext.SubmitChanges (on ConflictMode failureMode)code that caused the error:
var storedBug = DataContext.Bug_Tables.Where (b = & Gt; b.Id.Equals (bugToSave.Id)) FirstOrDefaul () .; StoredBug.Name = bugToSave.Name; StoredBug.DeveloperId = bugToSave.Developer == Zero? Blank: bugToSave.Developer.Id; StoredBug.TesterId = Bug-to-Save Teacher == Empty? Zero: bugToSave.Tester.Id; Storedbug.AssignedPersonId = bugToSave.AssignedPerson == Zero? Zero: bugToSave.AssignedPerson.Id; StoredBug.BugAreaId = bugToSave.BugArea.Id; StoredBug.BugStatusId = bugToSave.Status.Id; Storedblogpropertyid = bug-save.property == empty? Zero: bugToSave.Priority.Id; StoredBug.Description = bugToSave.Description; StoredBug.Notes = bugToSave.Notes; Archived box Recurrence = Bug-Save Repetition; StoredBug.FixedInBuild = bugToSave.FixInBuild; DataContext.SubmitChanges ();
/ Html>
Comments
Post a Comment