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; }