The [mapping table][1] is clear - `BIGINT` is the equivalent of `Int64` (which is `long` in C#).


  [1]: http://msdn.microsoft.com/en-us/library/cc716729.aspx

The equivalent type is [`bigint`][1] which is a 64-bit numeric type.

It fits numbers in the range from `-2^63` to `2^63-1` which is the same as the [C# `long` type][2].

  [1]: http://msdn.microsoft.com/en-us/library/ms187745.aspx
  [2]: https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/long

I have a method that looks like this:

    private async void DoStuff(long idToLookUp)
    {
        IOrder order = await orderService.LookUpIdAsync(idToLookUp);   
        
        // Close the search
        IsSearchShowing = false;
    }    

    //Other stuff in case you want to see it
    public DelegateCommand&lt;long&gt; DoLookupCommand{ get; set; }
    ViewModel()
    {
         DoLookupCommand= new DelegateCommand&lt;long&gt;(DoStuff);
    }    

I am trying to unit test it like this:

    [TestMethod]
    public void TestDoStuff()
    {
        //+ Arrange
        myViewModel.IsSearchShowing = true;

        // container is my Unity container and it setup in the init method.
        container.Resolve&lt;IOrderService&gt;().Returns(orderService);
        orderService = Substitute.For&lt;IOrderService&gt;();
        orderService.LookUpIdAsync(Arg.Any&lt;long&gt;())
                    .Returns(new Task&lt;IOrder&gt;(() =&gt; null));
        
        //+ Act
        myViewModel.DoLookupCommand.Execute(0);

        //+ Assert
        myViewModel.IsSearchShowing.Should().BeFalse();
    }

My assert is called before I get done with the mocked up LookUpIdAsync.  In my normal code, that is just what I want.  But for my Unit test I don&#39;t want that.

I am converting to Async/Await from using BackgroundWorker.  With background worker this was functioning correctly because I could wait for the BackgroundWorker to finish.

But there does not seem to be a way to wait for a async void method...

**How can I unit test this method?**

Await a Async Void method call for unit testing

What regular expression engine does Nginx use? [There are a lot of possibilities.](http://www.regular-expressions.info/refflavors.html) More to the point, what flavor of syntax does it support, that is, what syntax features can I make use of?

What regular expression engine does Nginx use?

I&#39;d like to know what the equivalent SQL Server type is for a `long` in C#.

What is the equivalent SQL Server type for the C# long type?

<p>I'd like to know what the equivalent SQL Server type is for a <code>long</code> in C#.</p>


how to get host domain from a string URL?

GetDomain has 1 input &quot;URL&quot;, 1 Output &quot;Domain&quot;


Example1

    INPUT: http://support.domain.com/default.aspx?id=12345
    OUTPUT: support.domain.com

Example2

    INPUT: http://www.domain.com/default.aspx?id=12345
    OUTPUT: www.domain.com

Example3

    INPUT: http://localhost/default.aspx?id=12345
    OUTPUT: localhost

Get host domain from URL?

I&#39;m looking for a rationale of why .NET `CancellationToken` struct was introduced in addition to `CancellationTokenSource` class. I understand _how_ the API is to be used, but want to also understand _why_ it is designed that way.

I.e., why do we have:

    var cts = new CancellationTokenSource();
    SomeCancellableOperation(cts.Token);

    ...
    public void SomeCancellableOperation(CancellationToken token) {
        ...
        token.ThrowIfCancellationRequested();
        ...
    }

instead of directly passing `CancellationTokenSource` around like:

    var cts = new CancellationTokenSource();
    SomeCancellableOperation(cts);

    ...
    public void SomeCancellableOperation(CancellationTokenSource cts) {
        ...
        cts.ThrowIfCancellationRequested();
        ...
    }

Is this a performance optimization based on the fact that cancellation state checks happen more frequently than passing the token around?

So that `CancellationTokenSource` can keep track of and update `CancellationTokens`, and for each token the cancellation check is a local field access?

Given that a volatile bool with no locking is enough in both cases, I still can&#39;t see why that would be faster.

Thanks!

Why CancellationToken is separate from CancellationTokenSource?

I am creating a simple wpf desktop application. UI have just a button and code in .cs file like.

    private void Button_Click_2(object sender, RoutedEventArgs e)
    {
        FunctionA();
    }

    public void FunctionA()
    {
        Task.Delay(5000).Start();
        MessageBox.Show(&quot;Waiting Complete&quot;);
    }

But surprisingly line `Task.Delay(5000).Start();` is throwing an `InvalidOperationException`: 

&gt;Start may not be called on a promise-style task. 

Can any one help why it is like this?

Start may not be called on a promise-style task. exception is coming

What is difference between .NET framework 4.0 `MemoryCache` vs `ObjectCache`?
Where to use which object?

What is difference between MemoryCache vs ObjectCache in .net 4.0?

I want to:
Export table from sql server database to a comma delimited `csv` file without using sql Server import export wizard

I want to do it using a query because I want to use the query in automation

Is it possible? I searched for that and didn&#39;t find a good answer

Export table from database to csv file

I want to select value = `201301`

    select getdate(), cast(datepart(year, getdate()) as varchar(4))+cast(datepart(MONTH, getdate()) as varchar(2))

it returns `20131`

what is the normal way to do this?

Convert date to YYYYMM format

Could you help me frame a query that retrieves the constraints in all the tables, the count of constraints in each table, and also display `NULL` for tables that do NOT have any constraints.

This is what I have so far:

    Select  SysObjects.[Name] As [Constraint Name] ,
    		Tab.[Name] as [Table Name],
    		Col.[Name] As [Column Name]
    From SysObjects Inner Join 
    (Select [Name],[ID] From SysObjects) As Tab
    On Tab.[ID] = Sysobjects.[Parent_Obj] 
    Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] 
    Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID]
    order by [Tab].[Name] 

SQL Server 2008- Get table constraints

I never use CTE with recursion. I was just reading an article on it. This article shows employee info with the help of Sql server CTE and recursion. It is basically showing employees and their manager info. I am not able to understand how this query works. Here is the query:

    WITH
      cteReports (EmpID, FirstName, LastName, MgrID, EmpLevel)
      AS
      (
        SELECT EmployeeID, FirstName, LastName, ManagerID, 1
        FROM Employees
        WHERE ManagerID IS NULL
        UNION ALL
        SELECT e.EmployeeID, e.FirstName, e.LastName, e.ManagerID,
          r.EmpLevel + 1
        FROM Employees e
          INNER JOIN cteReports r
            ON e.ManagerID = r.EmpID
      )
    SELECT
      FirstName + &#39; &#39; + LastName AS FullName,
      EmpLevel,
      (SELECT FirstName + &#39; &#39; + LastName FROM Employees
        WHERE EmployeeID = cteReports.MgrID) AS Manager
    FROM cteReports
    ORDER BY EmpLevel, MgrID

Here I am posting about how the output is showing:
![enter image description here][1]


  [1]: http://i.stack.imgur.com/03JpM.jpg

I just need to know how it is showing manager first and then his subordinate in a loop.
I guess the first sql statement fires only once and that returns all employee ids.

And the second query repeatedly fires, querying the database on which employee exists with the current manager id.

Please explain how the sql statement executes in an internal loop and also tell me the sql execution order. Thanks.

MY 2nd phase of question
--------------------------
    ;WITH Numbers AS
    (
        SELECT n = 1
        UNION ALL
        SELECT n + 1
        FROM Numbers
        WHERE n+1 &lt;= 10
    )
    SELECT n
    FROM Numbers

Q 1) how is the value of N is getting incremented? if the value is assigned to N every time then N value can be incremented but only the first time N value was initialized.

Q 2) CTE and recursion of employee relations:

The moment I add two managers and add a few more employees under the second manager is where the problem starts.

I want to display the first manager detail and in the next rows only those employee details that relate to the subordinate of that manager.

Suppose
----------

    ID     Name      MgrID    Level
    ---    ----      ------   -----
    1      Keith      NULL     1
    2      Josh       1        2
    3      Robin      1        2
    4      Raja       2        3
    5      Tridip     NULL     1
    6      Arijit     5        2
    7      Amit       5        2
    8      Dev        6        3


I want to display the results in such way with CTE expressions. Please tell me what to modify in my sql which I gave here in order to pull manager-employee relations. Thanks.

I want the output to be like this:
----------------------------------

    ID          Name   MgrID       nLevel      Family
    ----------- ------ ----------- ----------- --------------------
    1           Keith  NULL        1           1
    3           Robin  1           2           1
    2           Josh   1           2           1
    4           Raja   2           3           1
    5           Tridip NULL        1           2
    7           Amit   5           2           2
    6           Arijit 5           2           2
    8           Dev    6           3           2

Is this possible...?

SQL Server CTE and recursion example

I&#39;m trying to remove certain characters.

At the moment I have output like `cityname district` but I want to remove `cityname`.


    SELECT Ort FROM dbo.tblOrtsteileGeo
    WHERE GKZ = &#39;06440004&#39;

Output:

    B&#252;dingen Aulendiebach
    B&#252;dingen B&#252;ches
    B&#252;dingen Calbach
    B&#252;dingen Diebach
    B&#252;dingen Dudenrod
    B&#252;dingen D&#252;delsheim

Desired output:

    Aulendiebach
    B&#252;ches
    Calbach
    Diebach
    Dudenrod
    D&#252;delsheim


Content Type	Original Author	Original Content on Stackoverflow
Question	JanivZ	View Question on Stackoverflow
Solution 1 - C#	Oded	View Answer on Stackoverflow
Solution 2 - C#	Sergey Kalinichenko	View Answer on Stackoverflow

What is the equivalent SQL Server type for the C# long type?

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

What regular expression engine does Nginx use?

Await a Async Void method call for unit testing

Attributions