How to display data that I get from Database.SqlQuery in C#?

Question

This is the code snippet.

string query = "SELECT EnrollmentDate, COUNT(*) AS StudentCount "
            + "FROM Person "
            + "WHERE Discriminator = 'Student' "
            + "GROUP BY EnrollmentDate";

IEnumerable<EnrollmentDateGroup> data = db.Database.SqlQuery<EnrollmentDateGroup>(query);

System.IO.File.WriteAllText(@"C:\Users\Admin\Desktop\log.txt", data.ToString()); // or ToList()?

Now from my last line of code, I am getting a file with basically the same text that's there in the query. What I want to be displayed in my text file is the actual data from the database? How do I get that?

Suren Srapyan · Accepted Answer · 2016-07-29 07:56:41Z

2

data.ToString() returns the information about the class, not the data. You need to do like this

StringBuildet text = new StringBuilder();

data.ToList().ForEach(d => text.Append(/* Here what you want to do with each item of the EnrollmentDataGroup /*));

System.IO.File.WriteAllText(@"C:\Users\Admin\Desktop\log.txt", text);

First you need to cast to List for using the ForEach. Or you can write your own ForEach method for the type of IEnumerable

public static void ForEach<T>(this IEnumerable<T> enumeration, Action<T> action)
{
    foreach(T item in enumeration)
    {
        action(item);
    }
}

edited Jul 29, 2016 at 7:56

answered Jul 28, 2016 at 18:19

Suren Srapyan

68.9k14 gold badges128 silver badges119 bronze badges

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

1 Comment

Mike Nakis Over a year ago

For the love of anything that's holy to you (the FSM for me) use a StringBuilder instead of repeated string concatenation !

Md. Tazbir Ur Rahman Bhuiyan · Accepted Answer · 2016-07-28 18:47:48Z

1

SqlConnection sqlConnection1 = new SqlConnection("Your Connection String");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = "SELECT * FROM Customers";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

reader = cmd.ExecuteReader();
// Data is accessible through the DataReader object here.

sqlConnection1.Close();

reference: https://msdn.microsoft.com/en-us/library/fksx3b4f.aspx

answered Jul 28, 2016 at 18:47

Md. Tazbir Ur Rahman Bhuiyan

2,04221 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to display data that I get from Database.SqlQuery in C#?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related