GLOBAL SITES
 Home > Products > NObject O/R Mapping Framework > C# Examples

Please refer to online documents for more examples.

Insert new object

Customer customer = new Customer(objectManager);

// ...

customer.Save();

 

Order order = customer.NewOrder();

order.OrderDate = DateTime.Now;

order.ShipCity = city;

// ...

order.Save();

Batch Update

Order filter = new Order(objectManager);

filter.ShipVia = 1;

filter.EmployeeID = 7;

 

Order value = new Order(objectManager);

value.ShipVia = 3;

 

// BatchUpdate : using object filter

objectManager.UpdateMatch(filter, value);

 

// BatchUpdate : using OQL

objectManager.ExecuteCommand(

  OQL.Update(NW.Order)

    .Set(NW.Order.ShipVia, 3)

    .Where(NW.Order.ShipVia == 1 & NW.Order.EmployeeID == 7)

  );

Object Query Language Sample 1

// == C# Code ======================================================

SelectQuery qryOrder = OQL

  .SelectWhere(NW.Order == (NW.Customer.ContactTitle == "Owner"));

 

// ==== sql output for Microsoft Sql Server ========================

SELECT [Orders].*

FROM [Orders]

WHERE

  [Orders].[CustomerID] IN

    (

      SELECT [Customers].[CustomerID]

      FROM [Customers]

      WHERE

        [Customers].[ContactTitle] = 'Owner'

    )

 

// ==== sql output for Oracle ======================================

SELECT "Orders".*

FROM "Orders"

WHERE

  "Orders"."CustomerID" IN

    (

      SELECT "Customers"."CustomerID"

      FROM "Customers"

      WHERE

        "Customers"."ContactTitle" = 'Owner'

    ) 

Object Query Language Sample 2

// == C# Code ======================================================

SelectQuery sel = OQL

  .Select(NW.Order.OrderID,NW.Order.OrderDate,NW.Order.RequiredDate)

    ._(NW.OrderDetail)

  .From(NW.Order, NW.OrderDetail)

  .Where(NW.Order.EmployeeID == 5 && NW.Order.ShipVia == 1

    && NW.Order.OrderID == NW.OrderDetail.OrderID)

  .OrderBy(NW.Order.OrderID);

 

==== sql output for Microsoft Sql Server ============================

SELECT

  [Orders].[OrderID] , [Orders].[OrderDate] , [Orders].[RequiredDate]

  , [Order Details].*

FROM

  [Orders] , [Order Details]

WHERE

  [Orders].[EmployeeID] = 5 AND

  [Orders].[ShipVia] = 1 AND

  [Orders].[OrderID] = [Order Details].[OrderID]

ORDER BY [Orders].[OrderID]

 

==== sql output for Oracle =========================================

SELECT

  "Orders"."OrderID" , "Orders"."OrderDate" , "Orders"."RequiredDate"

  , "Order Details".*

FROM

  "Orders" , "Order Details"

WHERE

  "Orders"."EmployeeID" = 5 AND

  "Orders"."ShipVia" = 1 AND

  "Orders"."OrderID" = "Order Details"."OrderID"

ORDER BY "Orders"."OrderID"

Overview
Features
Download
Purchase
Requirements
Video Demos
C# Examples
VB.NET Examples
NObject Manual
NObject Help
OQL.NET Manual
Word to HTML help Word to Web help CHM to Web help CHM to Word CHM to HTML/MHTML .NET assembly Obfuscator