C# Extension Method: SqlConnection - ExecuteEntities

CSharp · Console

/Program.cs

// C# Extension Method
// Doc: https://csharp-extension.com/en/method/1002791/sqlconnection-executeentities

// @nuget: Z.ExtensionMethods

using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
					
public class Program
{
	public static void Main()
	{
		string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn UNION SELECT 2, 'BuzzBuzz' WHERE @Fizz = 1";
        var dict = new Dictionary<string, object> {{"@Fizz", 1}};
		
		using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
			conn.Open();
			
			//C# Extension Method: SqlConnection - ExecuteEntities
            List<TestObject> list = conn.ExecuteEntities<TestObject>(sql, dict.ToSqlParameters()).ToList();
			
			FiddleHelper.WriteTable(list);
        }
	}
	
	public class TestObject
    {
        public int IntColumn { get; set; }
        public string StringColumn { get; set; }
    }
}