biapar

Filter Queries - Example Use Cases

Here are a few example use cases, these use cases combine filter with other parameters to make useful API queries. The syntax for any of this may change between now, implementation, and release - they're meant as illustrative examples :)

Fetch 3 posts with tags which match 'photo' or 'video' and aren't the post with id 5.

api.posts.browse({filter: "tags:[photo, video] + id:-5", limit="3"});

GET /api/posts?filter=tags%3A%5Bphoto%2Cvideo%5D%2Bid%3A-5&limit=3

biapar

SQL Server data type          CLR data type (SQL Server)    CLR data type (.NET Framework)  
varbinary                     SqlBytes, SqlBinary           Byte[]  
binary                        SqlBytes, SqlBinary           Byte[]  
varbinary(1), binary(1)       SqlBytes, SqlBinary           byte, Byte[] 
image                         None                          None

varchar                       None                          None
char                          None                          None
nvarchar(1), nchar(1)         SqlChars, SqlString           Char, String, Char[]     
nvarchar                      SqlChars, SqlString           String, Char[] 

biapar

--from SO: http://stackoverflow.com/questions/5873170/generate-class-from-database-table

declare @TableName sysname = 'TableName'
declare @Result varchar(max) = 'public class ' + @TableName + '
{'

select @Result = @Result + '
    public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }
'
from

biapar

string url = "https://myurl.com";
string client_id = "client_id";
string client_secret = "client_secret";
//request token
var restclient = new RestClient(url);
RestRequest request = new RestRequest("request/oauth") {Method = Method.POST};
request.AddHeader("Accept", "application/json");
request.AddHeader("Content-Type", "application/x-www-form-urlencoded");
request.AddParameter("client_id", client_id);
request.AddParameter("client_secret", client_secret);

biapar

using FormsControls.Base;
using Xamarin.Forms;

namespace DemoNavigation
{
    public partial class RotatePage : ContentPage, IAnimationPage
    {
        public IPageAnimation PageAnimation { get; } = new RotatePageAnimation
        {
            Duration = AnimationDuration.Long,

biapar

using Microsoft.Exchange.WebServices.Data;
using System;
using System.Collections.Generic;


namespace ReadEmail365
{
    class Program
    {
        static void Main(string[] args)

biapar

       /// <summary>
        /// Handles the login form when user posts the form/attempts to login
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult HandleLogin(LoginViewModel model)
        {
            if (!ModelState.IsValid)
            {

biapar

/* Simple Social Icons
--------------------------------------------- */

.simple-social-icons li.social-dribbble a {
	border: 2px solid #ea4c89 !important;
	color: #ea4c89 !important;
}

.simple-social-icons li.social-dribbble a:hover {
	background-color: #ea4c89 !important;

biapar

using Umbraco.Core;
using Umbraco.Web;
using Umbraco.Web.Trees;
//https://github.com/marcemarc/uSpinMeRightRound/blob/master/Solution/tooorangey.uSpinMeRightRound/App_Start/RegisterEvents.cs
namespace tooorangey.uSpinMeRightRound.App_Start
{
    public class RegisterEvents : ApplicationEventHandler
    {
        protected override void ApplicationStarting(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
        {

biapar

@if (@Model.Content.GetPropertyValue("tags") != null)
{
	var tags = Model.Content.GetPropertyValue("tags").TryConvertTo<string>();
	string[] tagArray = { };
	if (tags.Success)
	{
		tagArray = tags.Result.Split(',');
	}

	if (tagArray.Any())