Step 1. Launch Visual Studio Code
Step 2. Terminal -> New Terminal or ctrl + shift + `
Step 2. Under Setting Terminal -> Integrated: CWD(Current Working Directory) set to c:\vscode
dotnet new console -o “ConsoleApp$(Get-Date -Format ‘yyyy-MM-dd-HHmm’)”; cd ConsoleApp$(Get-Date -Format ‘yyyy-MM-dd-HHmm’); code .\Program.cs
Switch between code and Terminal ctrl + `
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace DataBaseTest
{
class Program
{
static void Main(string[] args)
{
//1. Connect to database
SqlConnection myConnection = new SqlConnection(@"user id=UserName;" +
"password=**********;server=ServerName\\SQLEXPRESS;" +
"Trusted_Connection=yes;" +
"database=TravisTestDB; " +
"connection timeout=30");
myConnection.Open();
{
try
{
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand(@"select * from [User]", myConnection);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
Console.WriteLine(myReader[0].ToString());
Console.WriteLine(myReader[1].ToString());
Console.WriteLine(myReader[2].ToString());
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
myConnection.Close();
Console.Read();
}
}
}
}
WCF Operation Contract
[OperationContract] [WebInvoke(Method="POST", UriTemplate = "/AddNumbers", ResponseFormat= WebMessageFormat.Json, RequestFormat=WebMessageFormat.Json, BodyStyle= WebMessageBodyStyle.WrappedRequest)] int AddNumbers(int n1, int n2);
Interface Implementation
public int AddNumbers(int n1, int n2)
{
return n1 + n2;
}
JQuery .ajax request
function AddThis()
{
$.ajax(L_Menu_BaseUrl + "/_vti_bin/myServices.svc/AddNumbers",
{type: "POST",
data: JSON.stringify({ n1: 2, n2: 9 }),
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {alert("Success: " + data),
error: function (XMLHttpRequest, textStatus, errorThrown) { alert("error: " + textStatus + errorThrown + XMLHttpRequest);}
});
}
$('#AddMe').click(function () { AddThis(); });
Knowledge and Understanding of the following
Define the concept of a service, and to comprehend and explain the concept of service management as a practice.
Understand the value of the ITIL service lifecycle, how the processes integrate with each other, throughout the lifecycle, explain the objectives, scope and business value for each phase in the lifecycle.
Define key terminology and explain the key concepts of service management.
Understand models of service management and it’s opposing forces within service management.
How service management processes contribute to the service lifecycle. Explain the purpose, objective, scope, basic concepts, activities and interfaces of the
Purpose objectives, scope, basic concepts, process activities and interfaces fo:
Identify purpose, objectives, scope, basic concepts, process activities and interfaces
Identify purpose, objectives, scope, basic concepts, process activities and interfaces
Explain roles, objectives and organizational structures of the service desk function
Coordinates activities to deliver at agreed levels. Where all service processes come together.
You can invoke devenv.exe /diff File1.txt File2.txt from the command prompt or, if a Visual Studio instance is already running, you can type Tools.DiffFiles in the Command window, with a handy file name completion:
SharePoint Power Shell Command to extract error message from correlation ID across farm.
Merge-SPLogFile -Path “C:\Temp\error.log” -Correlation “ea4db39c-b73a-601a-c58f-6e5284175b86”
http://Flaticon.com
http://www.morguefile.com
SELECT * FROM sys.dm_fts_index_keywords(db_id(‘databasename’), object_id(‘tablename’))
SELECT * FROM sys.dm_fts_index_keywords_by_document(db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))
SELECT * FROM sys.dm_fts_index_keywords_by_property(db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))
SELECT * FROM sys.dm_fts_parser((db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))
Try
Catch ex As System.Data.Entity.Validation.DbEntityValidationException
For Each eve In ex.EntityValidationErrors
For Each e In eve.ValidationErrors
MsgBox(e.PropertyName & e.ErrorMessage)
Next
Next
End Try