CREATE VIEW OrdersProductsCustomers AS
SELECT Orders.CreatedAt AS OrderDate, 
        Customers.FirstName AS Customer,
        Products.ProductName As Product  
FROM Orders INNER JOIN Products ON Orders.ProductId = Products.Id
INNER JOIN Customers ON Orders.CustomerId = Customers.Id

        [HttpGet("{id}")]
        public IEnumerable<Contact> GetContact(int id)
        {
            string connectionString = @"stringconect...";
            string sqlExpression = "CREATE VIEW CON as SELECT * FROM contacts";
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand command = new SqlCommand(sqlExpression, connection);
                SqlDataReader reader = command.ExecuteReader();

            }
 как вернуть   return ?????????
        }