WCF service to SQL server Data Error

Hello All,

I am writing a WCF service that fetches data from SQL server database and shows it in front end using Linq to Entities.

Following is Class Interface:-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.ServiceModel;

namespace PIAService
{
    [ServiceContract]
    public interface IPIAService
    {
        [OperationContract]
        IQueryable<DataAccountDataModel> GetDetailsUsingPatientaccountNumber(string patientAccountNumber);
    }
}

Following is DataClass

public class DataAccountDataModel
  {
      [DataMember]
      public String PatientAccountNumber { get; set; }
      [DataMember]
      public String PatientName { get; set; }
      [DataMember]
      public String BARStatus_ORPH { get; set; }
      [DataMember]
      public String AdmitDate { get; set; }
}

Following is Interface Function Implementtion

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization;

using System.Data.Entity;
using StoreDB;

namespace PIAService
{
    [DataContract]
    public class PIAService : IPIAService 
    {

        public IQueryable <dataaccountdatamodel> GetDetailsUsingPatientaccountNumber(string patientAccountNumber)
        {
            PIADataModel piaData = new PIADataModel();
            
            IQueryable <dataaccountdatamodel> DAdetails = (from p in piaData.DataAccounts
                                                           where p.PatientAccountNumber == patientAccountNumber &&
                                                           p.Duplicate == false 
                                                           select p);

            return DAdetails;
         }
        
    }

By compiling this program i am getting the following error. Kindly help.

Error	1	Cannot implicitly convert type 'System.Linq.IQueryable<storedb.dataaccount>' to 'System.Linq.IQueryable<piaservice.dataaccountdatamodel>'. An explicit conversion exists (are you missing a cast?)

Thanks in Advance.

Chowdary.

Tags: C#, WCF, WPF, LINQ