Skip to content

Generator for sql scripts (tables hierarchy creation, content of object insertion). Automatic test for generated sql and cs code.

Notifications You must be signed in to change notification settings

miptleha/cs-query-generator

Repository files navigation

Query generator

Generation of sql scripts (creation and insertion) from cs-classes. Implemented for Oracle syntax.
Each class described by own method StoreInfo(): mapping between properties in class and fields in db, hierarchy between classes (inheritance, contains single, contains list).
For storing in Oracle db uses helper class.

Usage

  • Open QueryGenerator.sln in Visual Studio.
  • Open Program.cs. It contains automatic tests, that creates sql-database and perform insertion of test data.
  • Set connection to Oracle in App.config
  • Run application: it creates tables for 2 test classes: AF/TestClass1.cs and AF/TestClass2.cs
  • See console or bin/Debug/QueryGenerator.log for errors and output messages
  • All generated code are stored in bin/Debug/code folder

About

Generator for sql scripts (tables hierarchy creation, content of object insertion). Automatic test for generated sql and cs code.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages