Skip to content

Instantly share code, notes, and snippets.

View k4m4r82's full-sized avatar
🏠
Working from home

Kamarudin k4m4r82

🏠
Working from home
View GitHub Profile
Option Explicit
Public Function GetOpenConnection() As ADODB.Connection
Dim conn As ADODB.Connection
Dim strCon As String
On Error GoTo errHandle
strCon = "DRIVER=SQLite3 ODBC Driver;Database=" & App.Path & "\db\Northwind.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0"
Option Explicit
Public Sub Main()
' buat objek Order
Dim objOrder As New Order
With objOrder
.orderID = 123451
.customerID = "SUPRD"
.orderDate = "2016-2-6"
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Northwind.Model;
using Northwind.Repository.Api;
namespace Northwind.Repository.Service
{
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Northwind.Model;
using Northwind.Repository.Api;
namespace Northwind.Repository.Service
{
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Northwind.Model;
using Northwind.Repository.Api;
using Dapper;
namespace Northwind.Repository.Service
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Northwind.Model;
using Northwind.Repository.Api;
using Dapper;
namespace Northwind.Repository.Service
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Common;
using Northwind.Repository.Api;
namespace Northwind.Repository.Service
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Northwind.Model;
using Northwind.Repository.Api;
using Northwind.Repository.Service;
namespace Northwind.ConsoleApp
public class Category
{
public int CategoryID { get; set; }
public string CategoryName { get; set; }
public string Description { get; set; }
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Northwind.Repository.Api;
using System.Data;
namespace Northwind.Repository.Service
{