Databases
StackOverflow2013
Postsdbo
POInvalid Cast Exception, Stored Procedure, LINQ TO SQL
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInvalid Cast Exception, Stored Procedure, LINQ TO SQL
    text
    copied!<p>9 months later, the same problem shows up again. I've tried everything I can think of:</p> <ul> <li>I cast as varchar(max) on the stored procedure;</li> <li>I changed the mapping;</li> <li>tried to find the collection linq works with, but couldn't find anywhere;</li> </ul> <p>I have been running this stored procedure for some time Mapping it to my objects using LINQ to SQL, and now, all of the sudden, LINQ is trying to cast the field 'value' as double.</p> <hr> <p><strong>the error:</strong></p> <pre><code>specified cast is not valid System.Data.SqlClient.SqlBuffer.get_Double() System.Data.SqlClient.SqlDataReader.GetDouble(Int32 i) Read_Field(ObjectMaterializer`1 ) System.Data.Linq.SqlClient.ObjectReaderCompiler.ObjectReader`2.MoveNext() System.Linq.Enumerable.Single[TSource](IEnumerable`1 source) CmsCsharp.BL.FieldManager.FindContentField(Int32 id_content, Int32 id_fieldType, String fieldName) </code></pre> <hr> <p><strong>the methods</strong></p> <pre><code>public static Field FindContentField(int id_content, int id_fieldType, string fieldName) { using (DbBase conn = new DbBase()) { try { return conn.ClientDB.sprocFindContentField(id_content, id_fieldType, fieldName).Single(); } catch (Exception e) { return null; } } } [Function(Name = "dbo.sprocFindContentField")] public ISingleResult&lt;Field&gt; sprocFindContentField([Parameter(DbType="Int")] System.Nullable&lt;int&gt; id_content, [Parameter(DbType="Int")]System.Nullable&lt;int&gt; id_fieldType, [Parameter(DbType="Varchar(255)")]string fieldName) { IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), id_content, id_fieldType, fieldName); return ((ISingleResult&lt;Field&gt;)(result.ReturnValue)); } </code></pre> <hr> <p><strong>the field:</strong></p> <pre><code>public class TextField : Field { private string _Value; [Column(Storage="_Value", DbType="VarChar(MAX) NOT NULL", Name="value", CanBeNull=true)] public string Value { //get and set } } </code></pre> <hr> <p><strong>the procedure:</strong></p> <pre><code> SELECT type = 'textField', fieldLabel.id_fieldEditor, fieldLabel.id_fieldType , fieldLabel.description, fieldLabel.id , sessionField.id AS relationId, fieldLabel.name , fieldText.content AS value, fieldText.id AS valueId, cf.id as contentRelationId FROM fieldLabel INNER JOIN sessionField ON sessionField.id_fieldLabel = fieldLabel.id INNER JOIN cms_contentField AS cf ON cf.id_sessionField = sessionField.id INNER JOIN fieldText ON fieldText.id = cf.id_fieldValue INNER JOIN fieldType ON fieldLabel.id_fieldType = fieldType.id INNER JOIN fieldTable ON fieldTable.id = fieldType.id_fieldTable WHERE cf.id_content = @id_content AND fieldTable.id = 1 </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload