Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 5d9e8044f8
Fetching contributors…

Cannot retrieve contributors at this time

file 64 lines (52 sloc) 1.643 kb
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlServerCe;
using System.IO;
using PetaPoco;

namespace PetaPocoSample {
class Program {
static void Main(string[] args) {
var p = new Program();
p.CreateDatabase();

//var sample = new SingleTableSample();
//sample.CreateTable();
//sample.CreatePerson();
//sample.CreateDecoratedPerson();
////sample.SelectRecords();
////sample.SelectDecoratedRecords();
//sample.SelectSingleRecord();
//sample.SelectSingleDecoratedRecord();

//var sample = new TwoTableSample();
//sample.CreateTables();
////sample.QuerySeperately();
//sample.QueryMultiStyle();

//var sample = new UpdateSample();
//sample.CreateTables();
//sample.AddSelectAndUpdate();
//sample.AddSelectAndUpdateDecorated();
//sample.AddSelectAndUpdateASpecificField();
//sample.UpdateWithoutAPOCO();
//sample.UpdateWithAStatement();
//sample.InsertAndUpdateWithSave();

var sample = new ManyToOneSample();
sample.CreateTables();
sample.InsertTwoPersonsAndAnAddress();
sample.SelectUsingDecoratedClasses();
sample.SelectUsingMappingAndPOCO();
sample.SelectReportPOCO();
sample.SelectWithDynamics();
sample.SelectOneToMany();

Console.WriteLine("\nPress enter to continue");
Console.Read();
}

private SqlCeEngine CreateDatabase() {
if (File.Exists("test.sdf")) File.Delete("test.sdf");

string connectionString = "DataSource=\"test.sdf\"; Password=\"chrissiespassword\"";
var en = new SqlCeEngine(connectionString);
en.CreateDatabase();
return en;
}


}


}
Something went wrong with that request. Please try again.