Code Formatting Options Visual Studio

Text editor options

Convert IEnumerable of String to Int

Code

// ids is an IEnumerable of String

var integers = ids.Select(x => int.Parse(x));

// to convert and sort at the same time:

var sortedIds = ids.Select(x => int.Parse(x)).OrderBy(x => x));

Create XSD based on XML file

1. Open Visual Studio Command Propmt
2. Point to the directory where the xml is located in.
3. xsd filename.xml
4. A new .xsd file will be created in the same location.

Default Field Value at Table Creation Time

Syntax:

[FieldName] type CONSTRAINT [constraint_name] DEFAULT default_value

Example:

CREATE TABLE [Clients]

(

    ClientID  bigint   NOT NULL IDENTITY(1,1) CONSTRAINT [PK_Clients] PRIMARY KEY,

    CreatedOn datetime NOT NULL CONSTRAINT [DF_Clients_CreatedOnUtc] DEFAULT GETDATE()

    ...

)

And for an already created table:

ALTER TABLE Clients

ADD CONSTRAINT [DF_Clients_CreatedOn] DEFAULT GETDATE() FOR CreatedOn

Unique Fields at Table Creation Time

Sintax:

[FieldName] type CONSTRAINT [constraint_name] UNIQUE

Example:

CREATE TABLE [Clients]
(
    ClientID int NOT NULL IDENTITY(1,1) CONSTRAINT [PK_Clients] PRIMARY KEY,
    ServiceCode varchar(50) NOT NULL CONSTRAINT [UQ_Clients_ServiceCode] UNIQUE
    ...
)

Example 2:

CREATE TABLE [Clients]
(
    ClientID int NOT NULL IDENTITY(1,1) CONSTRAINT [PK_Clients] PRIMARY KEY,
    ServiceCode varchar(50) NOT NULL,
    CONSTRAINT [UN_Clients_Unique] UNIQUE (ClientID, ServiceCode)
    ...
)

jQuery ajax function template

Example

$.ajax({
    url: "/Home/Index",
    data: { email: email, username: username, etc: etc },
    success: function (data) {
        debugger; // remove debugger before check-in.
        $("#somelabel").text(data.SomeText);
    },
    type: "POST",
    dataType: 'json'
});

Another example

$.ajax(
{
    url: "/Account/LogOn",
    type: "POST",
    dataType: 'json',
    data: {
        username: $("txtUserName").val(), 
        password: $("txtPassword").val(),
        rememberMe: $("#chkRememberMe").is(':checked')
    },
    success: function (mydata) {
        if(mydata.Success) {
            alert(mydata.WelcomeMessage);
        }
        else{
            alert(mydata.Error);
        }
    }
});

Get Url - Protocol/Schema, Domain and (if applicable) Port

From goo.gl/WfuVV and goo.gl/AYp9v

Request.Url.GetLeftPart(UriPartial.Authority)

It will return a string like the following

"http://localhost:51528"

Requesr.Url properties and sample values:

Request.Url
{http://localhost:51528/Account/SendForgotPasswordEmail?email=jon@connor.com}
    AbsolutePath: "/Account/SendForgotPasswordEmail"
    AbsoluteUri: "http://localhost:51528/Account/SendForgotPasswordEmail?email=jon@connor.com"
    Authority: "localhost:51528"
    DnsSafeHost: "localhost"
    Fragment: ""
    Host: "localhost"
    HostNameType: Dns
    IsAbsoluteUri: true
    IsDefaultPort: false
    IsFile: false
    IsLoopback: true
    IsUnc: false
    LocalPath: "/Account/SendForgotPasswordEmail"
    OriginalString: "http://localhost:51528/Account/SendForgotPasswordEmail?email=jon@connor.com"
    PathAndQuery: "/Account/SendForgotPasswordEmail?email=jon@connor.com"
    Port: 51528
    Query: "?email=jon@connor.com"
    Scheme: "http"
    Segments: {string[3]}
    UserEscaped: false
    UserInfo: ""