Skip to content

Instantly share code, notes, and snippets.

View joacar's full-sized avatar

Joakim Lindh joacar

View GitHub Profile
@joacar
joacar / t-sql.sql
Created February 22, 2018 10:05
Import data into SQL from Google Spreadsheet or Microsoft Excel
-- Split string Table-Valued function
CREATE FUNCTION SplitString
(
@Input NVARCHAR(MAX),
@Character CHAR(1)
)
RETURNS @Output TABLE (
Item NVARCHAR(1000)
)
AS
@joacar
joacar / DbContextFactoryOfT.cs
Created May 17, 2017 08:43
Base class to configure and create instances of DbContext
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.Extensions.Configuration;
using System;
namespace CareBreeze.Data
{
public abstract class DbContextFactory<T> : IDbContextFactory<T> where T : DbContext
{
public string BasePath { get; protected set; }
@joacar
joacar / BindablePicker.cs
Created August 4, 2016 12:27
BindablePicker for Xamarin.Forms that handles Add, Remove, Reset,Clear and Move actions.
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Reflection;
using Xamarin.Forms;
namespace Clistr.Controls
{
public class BindablePicker : Picker
{
namespace Main
{
public partial class MainView : MasterDetailPage
{
public MainView()
{
InitializeComponent();
Detail = new NavigationPage(new StartView())
{
using System.ComponentModel;
using Android.App;
using Clistr.Droid.Renderers;
using Xamarin.Forms;
using Xamarin.Forms.Platform.Android;
#if __APPCOMPAT__
using NavigationRenderer = Xamarin.Forms.Platform.Android.AppCompat.NavigationPageRenderer;
using Toolbar = Android.Support.V7.Widget.Toolbar;
#else
using NavigationRenderer = Xamarin.Forms.Platform.Android.NavigationRenderer;