none
Unable to send Data Table as a parameter to WCF method , which is having 40000 rows RRS feed

  • Question

  • Hi ,

    I have tried with basicHttpBinding and wsHttpBinding , but I was not able to succeed while sending datatable as parameter to WCF method which is having 40000 rows . Please help me

    Thanks

    Murali

    Friday, March 30, 2018 8:09 AM

All replies

  • You don't send a datatable with 40,000 rows over WCF.

    Why?

    http://lauteikkehn.blogspot.com/2012/03/datatable-vs-list.html

    https://dzone.com/articles/reasons-move-datatables

    You send a serialized DTO in a collection.

    https://en.wikipedia.org/wiki/Data_transfer_object

    https://www.codeproject.com/Articles/1050468/Data-Transfer-Object-Design-Pattern-in-Csharp

    Friday, March 30, 2018 3:26 PM
  • Hi Murali,

    >>I was not able to succeed while sending datatable as parameter to WCF method which is having 40000 rows

    Do you receive any error? Do you mean you could not send datatable as parameter or you could not send the datatable which contains more than 40000 rows?

    As the link below, the Datatable is supported in WCF.

    #Using DataSet, Typed DataSet and DataTable

    https://docs.microsoft.com/en-us/dotnet/framework/wcf/feature-details/xml-and-ado-net-types-in-data-contracts#using-dataset-typed-dataset-and-datatable

    Could you share us a simple project which contains the Datatable with 40000 rows?

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, April 2, 2018 1:52 AM
  • Hi Tao Zhou ,

    Thanks for your reply .

    I am receiving below error

    " There was no endpoint listening at server address that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. "

    I am using basicHttp Binding here and have given maximum values for messageRecievingSize and etc , which is 2147483647

    Please help me

    Thanks and Regards

    Murali Krishna

    Monday, April 2, 2018 6:55 AM
  • For this error, it is not related with DataTable. 

    How did you generate the client code? If you access the wsdl address in web browser, will you receive any error?

    If you make a test with a simple WCF method, which will not use DataTable, will you receive the same error?


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, April 2, 2018 7:00 AM
  • i am not getting any error when am using service for other methods but when am using DataTable with data , I am getting this error . i.e., EndPointNotFoundException

    while browsing wsdl in browser also I am not getting any error .

    do I need to use any other binding than basicHttpBinding or any issues in my endpoint

    <

    endpointaddress=""binding="basicHttpBinding"contract="TestingBulkDataWCF.IService1"                 

    bindingConfiguration="basicBindingConfig">

    binding

    <

    bindingname="basicBindingConfig"receiveTimeout="00:20:00"sendTimeout="00:20:00"openTimeout="00:20:00"closeTimeout="00:20:00"


                   

    maxReceivedMessageSize="2147483647"


                   

    maxBufferSize="2147483647"


                   

    maxBufferPoolSize="2147483647"messageEncoding="Text">



              <

    readerQuotasmaxDepth="2147483647"


                           

    maxStringContentLength="2147483647"


                           

    maxArrayLength="2147483647"


                           

    maxBytesPerRead="2147483647"


                           

    maxNameTableCharCount="2147483647"/>



              <

    securitymode="None"></security>

             

            </

    binding>

    Please help

    Thanks and Regards

    Murali

    Monday, April 2, 2018 7:21 AM
  • Hi Tao Zhou ,

    Till 21000 rows , am able to send data but after that I am facing above mentioned error i.e., EndPointNotFoundException 

    Please suggest which binding I need to use to transfter large amount of data .

    please help me

    Thanks and Regards

    Murali Krishna

    Monday, April 2, 2018 8:15 AM
  • Hi Tao Zhou ,

    Till 21000 rows , am able to send data but after that I am facing above mentioned error i.e., EndPointNotFoundException 

    Please suggest which binding I need to use to transfter large amount of data .

    please help me

    Thanks and Regards

    Murali Krishna

    The client blew-up can't see how the endpointnotfound happens unless the service blewup too and is not there anymore, and somehow,  you are still trying to send records.

    <copied>

    do I need to use any other binding than basicHttpBinding or any issues in my endpoint

    <end>

    You need to use a Custom Binding on the service-side config to override the default binding settings, and you point to the Custom Binding.

     https://www.codeproject.com/Tips/243357/WCF-Custom-Binding

    Monday, April 2, 2018 9:31 AM