CODEWITHSUNDEEP
asp.netwcfentity-framework-4linq-to-entities
Jagadesh
Jagadesh

Reputation: 374

Unable to get data from WCF service using entity framework

I am using a web application where user pass one argument to the service and it will return string datatype which is query result. In the service i am using Entity Framework to query based on the user input but i am unable to get the data instead throwing an exception in my webapplication saying..... The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs. Webapplication and service are two different solutions. Code in My WCF service

public string GetFunctionality(string UserId)
    {
        string strRoleName = string.Empty;
        objEntity = new SYMPHONY_TVEntities();
        var Function = from t1 in objEntity.Users join t2 in objEntity.User_Role on t1.Role equals t2.User_Role1 where t1.UserID == UserId select t2;
        var UserName = from it in objEntity.Users where it.UserID == UserId select it;
        //Here i am getting exception
        User_Role objRole = Function.First();
        User objUser = UserName.First();
        if (objRole.User_Function != null && objUser.User_Name != null)
        {
            strRoleName = objRole.User_Function + "$" + objUser.User_Name;
        }
        return strRoleName;
    }

My connection string WCF service

<add name="SYMPHONY_TVEntities" connectionString="metadata=res://*/UsersModel.csdl|res://*/UsersModel.ssdl|res://*/UsersModel.msl;provider=System.Data.SqlClient;provider connection string='Data Source=inhi1u-hd0212\;Initial Catalog=&quot;SYMPHONY TV&quot;;Integrated Security=True;MultipleActiveResultSets=True'" providerName="System.Data.EntityClient" /></connectionStrings>

Upvotes: 0

Views: 690

Answers (1)

Flowerking
Flowerking

Reputation: 2581

You code looks ok. The exception says it is unable to connect to the db. This means your connection string might be wrong, please verify your connection string. If this fails try adding this line of code after your objEntity. (Why?)

objEntity = new SYMPHONY_TVEntities();
objEntity.Connection.Open();

Upvotes: 0

Related Questions