WCF Service Fails while Returning SQLConnection

Question

I have My Interface as :

 [ServiceContract]
    interface IDataRetrieve
    {
        [OperationContract]
        SqlConnection CreateSQLConnection(string connectionString);
        //DataSet GetSQLData(SqlConnection sqlConnection);
    }

and the Implementation as:

[DataContract]
    public class DataRetriever:IDataRetrieve
    {
        [OperationBehavior]
        public SqlConnection CreateSQLConnection(string connectionString)
        {

            SqlConnection connection = new SqlConnection(connectionString);
            return connection;
        }
}

Now while trying to access the service , getting unaccessible error.

The moment I change the return type of the method as void , service starts working. What am I doing wrong?

why do you want to return SqlConnection?

Ehsan
– Ehsan

2014-01-10 07:53:58 +00:00
Commented Jan 10, 2014 at 7:53 — Ehsan
– Ehsan, Commented Jan 10, 2014 at 7:53

ElDog · Accepted Answer · 2014-01-10 08:20:58Z

3

SqlConnection is not serializable so you can't return it from WCF service method. Also it has no sense because you will not be able to connect to sql server from another machine using this connection, you will need to create a new one. If passing a "connection" is a necessity you can pass a connection string and other settings necessary to create a connection.

answered Jan 10, 2014 at 8:20

ElDog

1,4171 gold badge12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

WCF Service Fails while Returning SQLConnection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related