Installation:
  1. Unzip Binaries to a local folder, or compile OpenORM.NET Source code.
  2. In Visual Studio (or SharpDevelop), go to Tools->External Tools  and add a new item, with 'Title' OpenORM.NET (or whatever you like)), 

External Tools

       3. Point to "OpenORM.UI.exe"  in 'Command'
       4. Set $(ProjectDir)  as 'Arguments'.  (If not configured, you get "Index was outside the bounds of the                      array" exception)

External Tools Dialog

      5. Access this tool As TOOLS-> External Tools -> OpenORM.NET.
 
Quick data access library creation sample:
  1. In a new instance of Visual Studio,create a new Class Library Project.
  2. Add a reference to System.Configuration.
  3. When you run (TOOLS->External Tools -> OpenORM.NET , (The project must be selected in Solution Explorer, NOT the Solution, because this tool needs to receive $(ProjectDir) argument) 
  4. The following screen will appear:

Initial Screen

  1. Configure connectionString, DbDriver and  Namespace (Sql Server, SQLite and Access by now).
  2. Select Tables,Views, Procedures and Functions that will be used in the future applications, and then select the plugin you need. 
  3. Accept for generation.
  4. Configure Solution Explorer to see all files and include them into the project (Exclude OpenORM.Project.xml if you wish).
  5. Compile, that's all for the data access project!
Testing:
  1. To test, add a Winforms project to the previous solution, and add a reference to the new library.
  2. Add an AppConfig (You can generate one with the corresponding plugin or copy -as reference- one of the configuration files included in the binary folder and edit with your own information)
  3. Bind a control to a 'Items()' Method, as you can see in the following examples:

Detailed examples:

Selecting from Tables and views

Executing a stored procedure

Inserting data

Updating data

Deleting data

Roadmap:

  • Encryption support for data and configuration files.
  • Support for spaces in fields names in entities. (Added.Will be available in next release).
  • MARS support (Multiple Active Result Set).
  • Support for SQL Server User-Defined Data Types.
  • MySQL  and PostgreSQL support.

     

 

Last edited Dec 8, 2015 at 5:19 PM by cdcespon, version 28