public BodyTypeRepository(NpgSqlDataContext db)
{
_db = db;
}
public VehicleRepository(NpgSqlDataContext data)
{
_data = data;
}
public TiresController(NpgSqlDataContext context)
{
_context = context;
}
public GenericRepository(NpgSqlDataContext context)
{
_context = context;
_dbSet = context.Set <TEntity>();
}
public OilsController(NpgSqlDataContext context)
{
_context = context;
}
public ManufactersController(NpgSqlDataContext context)
{
_context = context;
}
public CarRepository(NpgSqlDataContext context)
{
_db = context;
}
public ManufactersRepository(NpgSqlDataContext context)
{
_data = context;
}
public VehicleDrivesController(NpgSqlDataContext context)
{
_context = context;
}
static void Main(string[] args)
{
using (var dc = new NpgSqlDataContext("Host=localhost;Username=postgres;Password=admin;Database=TEST")
.MapComposite <Test>("Test")
.MapComposite <TestLink>("TestLink"))
{
var r0 = dc.Query(@"SELECT * FROM orders");
PrintTable(r0);
var r1 = dc.Query(@"SELECT * FROM orders where customer_id=@customer_id",
new NpgsqlParameter("customer_id", 23));
PrintTable(r1);
// using table valued parameters
// Postgres doesn't have tvp - they are mimicked by arrays of regular or Composite types
var r3 = dc.Query(@"
SELECT c.*
FROM customers c
INNER JOIN UNNEST(@ageval_tvp) tvp ON
c.age = tvp",
new NpgsqlParameter(
"ageval_tvp",
new int[] { 25, 31, 39 })
);
PrintTable(r3);
// tvp of composite type
dc.MapComposite <customer>("customers");
var r4 = dc.Query(@"
SELECT c.*
FROM customers c
INNER JOIN UNNEST(@x_customer) x ON
c.age = x.age AND
c.name = x.name",
new NpgsqlParameter(
"x_customer",
new customer[] {
new customer()
{
name = "Phil", age = 43
},
new customer()
{
name = "Barry", age = 39
}
}
)
);
PrintTable(r4);
dc.MapComposite <order>("orders");
var r6 = dc.Query(@"
INSERT INTO orders (customer_id, item)
SELECT customer_id, item from UNNEST(@x_orders) returning order_id",
new NpgsqlParameter(
"x_orders",
new order[] {
new order()
{
customer_id = 22, item = "cc"
},
new order()
{
customer_id = 23, item = "dd"
}
})
);
PrintTable(r6);
var r7 = dc.Execute(@"
WITH customer as (insert into customers(name, age) values ('Ghan', 55) returning customer_id)
INSERT INTO orders(customer_id, item)
SELECT c.customer_id, x.item FROM customer c CROSS JOIN UNNEST(@x_orders) x
",
new NpgsqlParameter(
"x_orders",
new order[] {
new order()
{
item = "gg"
},
new order()
{
item = "hh"
}
}
)
);
Console.WriteLine("Inserted {0} rows", r7);
// case sensitive names
var query = @"
WITH Customer AS (INSERT INTO ""Test"" (""Name"", ""Age"")
SELECT ""Name"", ""Age""
FROM UNNEST(@TestItems) returning ""TestID"")
INSERT INTO ""TestLink"" (""TestID"")
SELECT c.""TestID"" FROM Customer c
";
var query1 = @"
WITH Customer AS (INSERT INTO ""Test"" (""Name"", ""Age"")
SELECT ""Name"", ""Age""
FROM UNNEST(@TestItems) returning ""TestID"")
INSERT INTO ""TestLink"" (""TestID"", ""LinkName"")
SELECT c.""TestID"", x.""LinkName"" FROM Customer c CROSS JOIN UNNEST (@TestLinkItems) x
";
var x = dc.Execute(query,
new NpgsqlParameter("TestItems", new Test[] { new Test()
{
Name = "Sam", Age = 25
} }));
Console.WriteLine("Inserted rows {0}", x);
var y = dc.Execute(query1,
new NpgsqlParameter(
"TestItems",
new Test[] { new Test()
{
Name = "Sam", Age = 25
} }),
new NpgsqlParameter(
"TestLinkItems",
new TestLink[]
{
new TestLink()
{
LinkName = "xxx"
},
new TestLink()
{
LinkName = "yyy"
}
}));
Console.WriteLine("Inserted rows {0}", y);
}
Console.ReadKey();
}
public OilRepository(NpgSqlDataContext db)
{
Db = db;
}
public CarCharacteristicsRepository(NpgSqlDataContext db)
{
_db = db;
}
public UsersController(NpgSqlDataContext context)
{
_context = context;
}
