<pre>
[OperationContract]
public List<resultingClass>() RunSomeDataFromProcedure()
{
List<resultingClass> result = new List<resultingclass>();
String connectionString = "Your connection string";
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = connectionString;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "EXECUTE [DBNAME].[dbo].[StoredProcName] Parameters";
System.Data.SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
ResultingClass item = new ResultingClass();
item.Field1 = dataReader["Field1"].ToString();
...
..
.
}
return result;
}