CRUD пример

[OperationContract]
		[WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
		public string set(string data)
		{
			var userConnection = (UserConnection)HttpContext.Current.Session["UserConnection"];
			var insert = new Insert(userConnection).Into("UsrTest")
			.Set("UsrAccessTokenString", Column.Const("SOME_TOKEN"))
			.Set("UsrAccessTokenRefresh", Column.Const("SOME_REFRESH_TOKEN"));
			return "Hello";
		}
 
		[OperationContract]
		[WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
		public string get(string data)
		{
			var text = "Data: ";
			var userConnection = (UserConnection)HttpContext.Current.Session["UserConnection"];
			Select selectQuery = new Select(userConnection)
				.Column("UsrAccessTokenString")
				.Column("UsrAccessTokenRefresh")
				.From("UsrTest");
			// Выполнение запроса к базе данных и получение результирующего набора данных.
			using (DBExecutor dbExecutor = userConnection.EnsureDBConnection())
			{
				using (IDataReader reader = selectQuery.ExecuteReader(dbExecutor))
				{
					while (reader.Read())
					{
						text = "TOKEN: " + reader.GetString(0) + " REFRESH: " + reader.GetString(1) + "; ";
					}
				}
			}
			return text;
		}