Filling custom C# objects from data received stored procedure

c#, stored-procedures

Solution

Use ADO.NET, open a SqlDataReader on a SqlCommand object executing the SP with the parameters. Use the SqlDataReader.NextResult method to get the second result set.

Basically:

SqlConnection cn = new SqlConnection("<ConnectionString>");
cn.Open();

SqlCommand Cmd = new SqlCommand("<StoredProcedureName>", cn);
Cmd.CommandType = System.Data.CommandType.StoredProcedure;

SqlDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);

while ( dr.Read() ) {
    // populate your first object
}

dr.NextResult();

while ( dr.Read() ) {
    // populate your second object
}

dr.Close();

Problem

``` public class User { public string FirstName { get; set; } public string LastName { get; set; } } public class Address { public string City { get; set; } public string Country { get; set; } } /* * There are 2 c# objects i have shown * There is a stored procedure in my application which * returns data for both objects simultaneously * eg * select FirstName, LasteName from Users where something="xyz" * select City,Country from Locations where something="xyz" * * both queries are run by single procedure * Now how can i fill both objects with from that stored procedure in asp.net using c# */ ```

Original source