Récupérer de Multiples domaines à partir de SQL Server dans un service web?

En plus de l'injection SQL, peu de choses:

Créer un DataContract et de créer un modèle pour les données que vous souhaitez retourner

[DataContract]
public class Employee
{
    [DataMember]
    public int NTID { get; set; }

    [DataMember]
    public string LastName { get; set; }

    [DataMember]
    public int FirstName { get; set; }
}

Combler ce modèle avec vos résultats de la Requête SQL et de retour de votre service

    //create new method to get Employee record based on First Name
    public static List<Employee> GetEmployee(string firstName)
    {
        //Create Connection
        SqlConnection con = new SqlConnection (@"Data Source=myDBServer;Initial Catalog=MyDataBase;Integrated Security=true;");

        //Sql Command
        SqlCommand cmd = new SqlCommand("Select NTID, LastName, FirstName from Employees where FirstName ='" + firstName.ToUpper() + "'", con);

        //Open Connection
        con.Open();

        List<Employee> employees = new List<Employee>();

        //To Read From SQL Server
        SqlDataReader dr = cmd.ExecuteReader();

        while (dr.Read())
        {
            var employee = new Employee { 
                       NTID = dr["NTID"].ToString();
                       LastName = dr["LastName"].ToString();
                       FirstName = dr["FirstName"].ToString();
                    };
            employees.Add(employee);
        }
        //Close Connection
        dr.Close();
        con.Close();
        return employees;
}

Exposer:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;

namespace EmployeeRecs
{
    ///<summary>
    ///Summary description for Service1
    ///</summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    //To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    //[System.Web.Script.Services.ScriptService]
    public class Service1 : System.Web.Services.WebService
    {

               //Create new web method to get Employee last name
        [WebMethod]
        public List<Employee> GetEmployee(string firstName)
        {
            return DataHelper.GetEmployee(firstName);

        }
    }
}

Code complet de l'OP pour la postérité:

Ce qui peut être utile à d'autres personnes aux prises avec la même situation. Donc, je m de poster mon code pour la solution:
Créer un nouveau Projet WCF dans VS 2010, j'ai utilisé .net version 3.5 et sélectionné WCF Service de la Bibliothèque, en vertu de la WCF modèle.

Voici mon code sous IService1.cs

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Runtime.Serialization; 
using System.ServiceModel; 
using System.Text; 
namespace WcfServiceLibrary1 
{ 
//NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together. 
[ServiceContract] 
public interface IService1 
{ 
[OperationContract] 
List<Employee> GetEmployee(string firstName); 
[OperationContract] 
CompositeType GetDataUsingDataContract(CompositeType composite); 
//TODO: Add your service operations here 
} 
//Custon Data contract 
[DataContract] 
public class Employee 
{ 
[DataMember] 
public string FirstName { get; set; } 
[DataMember] 
public string LastName { get; set; } 
[DataMember] 
public string Email { get; set; } 
[DataMember] 
public string University { get; set; } 
}  
//Use a data contract as illustrated in the sample below to add composite types to service operations 
[DataContract] 
public class CompositeType 
{ 
bool boolValue = true; 
string stringValue = "Hello "; 
[DataMember] 
public bool BoolValue 
{ 
get { return boolValue; } 
set { boolValue = value; } 
} 
[DataMember] 
public string StringValue 
{ 
get { return stringValue; } 
set { stringValue = value; } 
} 
} 
} 

Et voici mon code en vertu de Service1.cs

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Runtime.Serialization; 
using System.ServiceModel; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
namespace WcfServiceLibrary1 
{ 
//NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in both code and config file together. 
public class Service1 : IService1 
{ 
public List<Employee> GetEmployee(string firstName)  
{ 
//Create Connection  
SqlConnection con = new SqlConnection(@"Data Source=gsops4;Initial Catalog=MultiTabDataAnalysis;Integrated Security=true;"); 
//Sql Command  
SqlCommand cmd = new SqlCommand("Select LastName, FirstName, Email, University from Employees where FirstName ='" + firstName.ToUpper() + "'", con); 
//Open Connection  
con.Open(); 
List<Employee> employees = new List<Employee>(); 
//To Read From SQL Server  
SqlDataReader dr = cmd.ExecuteReader();  
while (dr.Read())  
{  
var employee = new Employee {   
FirstName = dr["FirstName"].ToString(),  
LastName = dr["LastName"].ToString(), 
Email = dr["Email"].ToString(), 
University = dr["University"].ToString() 
};  
employees.Add(employee);  
}  
//Close Connection  
dr.Close();  
con.Close();  
return employees; 
} 
public CompositeType GetDataUsingDataContract(CompositeType composite) 
{ 
if (composite == null) 
{ 
throw new ArgumentNullException("composite"); 
} 
if (composite.BoolValue) 
{ 
composite.StringValue += "Suffix"; 
} 
return composite; 
} 
} 
} 

OriginalL'auteur Jaime Torres