Populate a DataSet using Context - Entity Framework 4

Question

I have some Data returning from a Context. Data has being pulled by spCmsCategoriesReadHierarchy.

I need take all Data from Context and populate my DataSet. My final goal is to populate a TreeView Control with DataSet object.

Any ideas? Thanks for your time and patience.

using (TestHierarchyEntities context = new TestHierarchyEntities())
{
    int n = 0;
    Int16 sl = 1;
    ObjectParameter nn = new ObjectParameter("nn", typeof(int));

    // Create a Data Set where adding the result of context 
    DataSet dataSet = new DataSet("myDataSet");

    foreach (CmsCategory categories in context.spCmsCategoriesReadHierarchy(n,sl,nn))
    {
    }
}

Why are you using EF if you need data sets? Seems like a waste of time. — user1228
– user1228, Commented Jan 7, 2011 at 14:12
Will I think you are right! Do you know how to bind a TreeView using the context (EF)? thanks — GibboK
– GibboK, Commented Jan 7, 2011 at 14:16

Brian Mains · Accepted Answer · 2011-01-07 14:08:21Z

5

Sure, you can manually copy the data over from the object to a data row within the dataset.

DataSet dataSet = new DataSet("myDataSet");
dataSet.Tables.Add(new DataTable());
//Setup the table columns.

foreach (CmsCategory categories in context.spCmsCategoriesReadHierarchy(n,sl,nn))
{
    DataRow row = dataSet.Tables[0].NewRow();
    row["A"] = categories.A;
    row["B"] = categories.B;

    dataSet.Tables[0].Rows.Add(row);
}

If you are not looking to explicitly copy over the properties to the data row, you can also use reflection to do the copying.

answered Jan 7, 2011 at 14:08

Brian Mains

50.8k35 gold badges155 silver badges260 bronze badges

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

3 Comments

GibboK Over a year ago

Hi Brina thanks. As i wrote my idea is to populate a TreeView control with a DataSet. Because I use EF 4 would be possible to bind to TreeView directly to EF without use any DataSet? I really appreciate your help on this! Are you able to provide a piece of code to start with?

Brian Mains Over a year ago

Sure, you can always bind with EF objects, are you using the ASP.NET tree view? If so, you can easily translate the inner loop, and instead of creating a DataRow object, you create a TreeNode object. If using the datasource approach, I'm not sure 100% about the hierarchical binding approach, but it seems like since each EF object contains its relationships as properties for that entity, you could easily recreate the hierarchical structure.

GibboK Over a year ago

Thanks Brina, for sure I will try and post the code for other references. Thanks for now

Richard C · Accepted Answer · 2020-11-03 11:57:07Z

This method will call a stored procedure in your database and fill a data set with the result:

var dataSet = new DataSet();
using ( var sqlCmd = context.Database.Connection.CreateCommand() )
{
    sqlCmd.CommandType = CommandType.StoredProcedure;
    sqlCmd.CommandText = "spCmsCategoriesReadHierarchy";
    // sqlCmd.Parameters.Add( new SqlParameter( "@Parameter", value ) );
    // sqlCmd.Parameters.Add( new SqlParameter( "@Error", null ) { Direction = ParameterDirection.Output, Size = -1 } );

    // Define the data adapter and fill the dataset 
    using ( DbDataAdapter da = new SqlDataAdapter() )
    {
        da.SelectCommand = sqlCmd;
        da.Fill( dataSet );
    }
    // resultDetail.Error = sqlCmd.Parameters["@Error"].Value.ToString();
}

The comments show how to pass parameters bi-directionally.

p.s.: We're using Entity Framework 6. I don't know if this would work on EF4.

Community · Accepted Answer · 2017-05-23 12:10:22Z

0

This method will convert a list of objects to a datatable. It was given as an answer to this question.

/// <summary>
/// Create data table from list.
/// https://stackoverflow.com/questions/18746064/using-reflection-to-create-a-datatable-from-a-class
/// </summary>
public static DataTable CreateDataTable<T>(IEnumerable<T> list)
{
    Type type = typeof(T);
    var properties = type.GetProperties();      

    DataTable dataTable = new DataTable();
    foreach (PropertyInfo info in properties)
    {
        dataTable.Columns.Add(new DataColumn(info.Name, Nullable.GetUnderlyingType(info.PropertyType) ?? info.PropertyType));
    }

    foreach (T entity in list)
    {
        object[] values = new object[properties.Length];
        for (int i = 0; i < properties.Length; i++)
        {
            values[i] = properties[i].GetValue(entity);
        }

        dataTable.Rows.Add(values);
    }

    return dataTable;
}

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Apr 7, 2017 at 19:22

Hans Vonn

4,1293 gold badges24 silver badges15 bronze badges

1 Comment

David Over a year ago

Rather than just copying code and pasting here as an answer, it would be better if you tailored it more to the OP's question. For example, OP asked for a DataSet, and this returns a DataTable. It would also be nice if you included a way to go from OP's code snippet to the code you provide--for example, "Replace your foreach statement with CreateDataSet(context.spCmsCategoriesReadHierarchy(n,sl,nn))" or something like that.

Collectives™ on Stack Overflow

Populate a DataSet using Context - Entity Framework 4

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related