Entity framework give error on live server

Question

Hi I am get issue pls help me to fix this The data reader returned by the store data provider does not have enough columns for the query requested. Server stack trace: at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply MessageFault fault String action MessageVersion version FaultConverter faultConverter) at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action Boolean oneway ProxyOperationRuntime operation Object[] ins Object[] outs TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action Boolean oneway ProxyOperationRuntime operation Object[] ins Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData Int32 type)

Ajitender Vijay · Answer

yes...

Dorababu Meka · Answer

Are you able to see you column information as per marked in the red or you are getting that error while importing a function

Ajitender Vijay · Answer

Yes... i had created a new complex of all return column

Dorababu Meka · Answer

Ok are you able to see the column information when you generate a New complex type?

Ajitender Vijay · Answer

by importing as function in EF model

Dorababu Meka · Answer

Hi how you are calling your stored procedure by importing as function in EF model or using StoreCommand

Ajitender Vijay · Answer

Hi babu Yes you are right i am using stored procedure. here is the SP code but it's working fine on development environment CREATE PROCEDURE [dbo].[GetInstallersByNameCode] -- Add the parameters for the stored procedure here @installerName nvarchar(50) @installerCode nvarchar(50) AS BEGIN TRY BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SELECT TOP 50 [Installer].[InstallerCompanyID] [Installer].[CompanyName] [InstallerAddress].[PostCode]PostCode [InstallerAddress].[Town] FROM [ARC_Ordering].[dbo].[Installer] inner join [ARC_Ordering].[dbo].[InstallerAddress] ON Installer.AddressID = InstallerAddress.AddressID where IsActive = 1 AND (CompanyName like '%'+@installerName+'%' OR InstallerCode like '%'+@installerCode+'%') ORDER BY CompanyName ASC END END TRY BEGIN CATCH EXEC USP_SaveSPErrorDetails --RETURN -1 END CATCH

Dorababu Meka · Answer

Are u using stored procedure to get the data if so can you post that procedure