Thorsten Dittmar tdittmar

## force_tls.cs
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls |
                                       SecurityProtocolType.Tls11 |
                                       SecurityProtocolType.Tls12;

## parameterized_top.sql
CREATE PROCEDURE dbo.sp_TestGetAll
    @LIMIT INT
AS
    SELECT TOP (@LIMIT) id, col1, col2, col3 FROM TestTable

## paginate.sql
DECLARE @pageNo INT
DECLARE @pageSize INT

SET @pageNo = 2
SET @pageSize = 15

SELECT
    CustomerNo,
    FirstName,
    LastName

## wpf_listbox_same_column_width.cs
<Grid.ColumnDefinitions>
      <ColumnDefinition SharedSizeGroup="col1" />
      <ColumnDefinition SharedSizeGroup="col2" />
</Grid.ColumnDefinitions>

## transpose_result.sql
DECLARE @test NVARCHAR(MAX)
SELECT @test = COALESCE(@test + ', ', '') + Field FROM <Sampletable> WHERE <whereclause> AND Field IS NOT NULL
SELECT @test

## passing_object_right.cs
StateObject object = new StateObject();
object.Number = 5;
System.Threading.Timer timer = new System.Threading.Timer(new TimerCallback(callback), object, ...);

## nth-row.sql
declare @whichRow INT
set @whichRow = 5

select top 1 * from
(
    select top (@whichRow) * from <thetable> where <whereclause> order by <orderbyclause> desc
) tmp
order by id asc

## dynamic_object.cs
dynamic test = new {
    id = 12345,
    additionalData = new
    {
        something = "Hello World",
        subItems = new List<object>()
        {
            new {
                test1 = "this",
                test2 = "is"