LINQ and SQL Server Compact

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<span class=Apple-style-span style="word-spacing:0px;font:16px Times New Roman;text-transform:none;color:rgb(0,0,0);white-space:normal;letter-spacing:normal;border-collapse:separate <font style="font-size:14px" face=Verdana>Hello! </font>
<div style="font-size:12px;font-family:Verdana


<font style="font-size:14px In my project I try to remove data from SQL Server Compact database. </font>
<font style="font-size:14px I using LINQ:</font>
<font style="font-size:14px
</font>

<font style="font-size:14px </font> <font style="font-size:14px
<div style="border-right:#7f9db9 1px solid;border-top:#7f9db9 1px solid;font-size:11px;overflow:auto;border-left:#7f9db9 1px solid;line-height:100%! important;border-bottom:#7f9db9 1px solid;font-family:Courier New;background-color:white
<table style="border-top-width:0px;border-left-width:0px;margin:2px 0px;width:99%;border-bottom:#eee 0px solid;border-collapse:collapse;background-color:#fff;border-right-width:0px" cellspacing=0 cellpadding=0>
<colgroup>
<col style="padding-left:10px;font-size:11px;border-bottom:#f7f7f7 1px solid;font-family:Courier New;white-space:nowrap
<tbody>
<tr>
<td><font style="font-size:11px database.Messages.DeleteOnSubmit( message );  </font></td></tr>
<tr>
<td style="background-color:#f7f7f7 database.SubmitChanges(); </td></tr></tbody></table>
</font>
<font style="font-size:14px "message" contains column with "Image" data type in database and I get NotSupportedException: "SQL Server does not handle comparison of NText, Text, Xml, or Image data types".
</font>
<span class=Apple-style-span style="font-size:13px;font-family:-webkit-monospace <font style="font-size:14px
Could someone help me how avoid this problem?</font>

View the full article
 
Back
Top