DbCommand - ExecuteExpandoObject
A DbCommand extension method that executes the expando object operation.
public static void Main() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn"; using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer())) { conn.Open(); using (DbCommand command = conn.CreateCommand()) { command.CommandText = sql; //C# Extension Method: DbCommand - ExecuteExpandoObject dynamic entity = command.ExecuteExpandoObject(); Console.WriteLine(entity.IntColumn); Console.WriteLine(entity.StringColumn); } } }
View Source
using System.Data; using System.Data.Common; public static partial class Extensions { /// <summary> /// A DbCommand extension method that executes the expando object operation. /// </summary> /// <param name="this">The @this to act on.</param> /// <returns>A dynamic.</returns> public static dynamic ExecuteExpandoObject(this DbCommand @this) { using (IDataReader reader = @this.ExecuteReader()) { reader.Read(); return reader.ToExpandoObject(); } } }