public void Linq7() {

    List products = GetProductList();



    var productNames =

        from p in products

        select p.ProductName;

    

    Console.WriteLine("Product Names:");

    foreach (var productName in productNames) {

        Console.WriteLine(productName);

    }

}

CREATE PROC usp_configure_maxReplSize 

   @NewSize int = 1000000

AS 

    exec sp_configure 'max text repl size' 

    exec sp_configure 'max text repl size', @NewSize

    RECONFIGURE WITH OVERRIDE

    

    exec sp_configure 'max text repl size'

GO