WCF service returns null for a column in SP

I have a stored proc where one of the columns is

sum(Value)/sum(qty) * sum(Requested) as ValueReq

Value, qty and Requested are columns of a table with datatype as numeric(20,0) in sql server. In the linq to sql class, ValueReq is declared as

private System.Nullable<decimal> ValueReq

Although the query returns non zero values as result in the sql server(ex:14999746025.910250), the WCF service message always returns the result as null <a:ValueReq i:nil="true"/>

Here is the web.config on service

<system.serviceModel>
  <serviceHostingEnvironment aspNetCompatibilityEnabled="true"/>
  <behaviors>
   <serviceBehaviors>
    <behavior name="Service.ServiceBehavior">
     <serviceMetadata httpGetEnabled="true"/>
     <serviceDebug includeExceptionDetailInFaults="true"/>
     <dataContractSerializer maxItemsInObjectGraph="2147483647"/>
    </behavior>
   </serviceBehaviors>
  </behaviors>
  <bindings>
   <basicHttpBinding>
    <binding name="BasicHttpBinding_Service" maxBufferSize="2147483647" maxReceivedMessageSize="2147483647" receiveTimeout="00:40:00" openTimeout="00:40:00" closeTimeout="00:40:00" sendTimeout="00:40:00">
     <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647"/>
     <security mode="None"/>
    </binding>
   </basicHttpBinding>
   <customBinding>
    <binding name="Service.Service.customBinding0">
     <binaryMessageEncoding/>
     <httpTransport/>
    </binding>
   </customBinding>
  </bindings>
  <services>
   <service behaviorConfiguration="Service.ServiceBehavior" name="Service.Service">
    <endpoint address="" binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_Service" name="BasicHttpBinding_Service" contract="Service.IService"/>
   </service>
  </services>
 </system.serviceModel>

Any reason why I am facing this issue?

ansaurus

tags:

views:

answers:

WCF service returns null for a column in SP

related questions