Click here to Skip to main content
Click here to Skip to main content

Build Data Access Layer and Entity Layer in 20 Seconds

, 5 Nov 2007 CPOL
Rate this:
Please Sign up or sign in to vote.
Give the Oracle Connection string and Get the DAL and Entity Layer in 5 steps
Screenshot - Demo.jpg

Introduction

The small utility tool has been developed for rapid development of Data Access Layer and Entity Layer.

I am a Software Programmer and I have to make Data Access Layer and Entity Layer for the procedures I made in Oracle. For each parameter in Procedure, I have to create a property with get and set in Entity Layer Class and have to build oracleParameterCollection in DAL. For the procedures that have 30 to 40 parameters, I have to code around 600 lines, which is very boring and time consuming.

I decided that most of the things of DAL and Entity layer are static, only the property and variable name change, why can I loop through each parameter of Procedure and make code string for every parameter.

So, my first problem is how to get all the procedure names and then all the parameter names of procedure. I found SQL Queries for that and also found .NET method of our OracleConnection class, obj_Connection.getSchema() which gives us all the data about the current connection with current Oracle schema.

Finally the application has been developed and now you can make your DAL and Entity Layer within 20 seconds in 5 steps.

You just need to give your connection string.

Select the Procedure, click on make Entity, Make DAL Button and you will get the code.

You can directly save Entity and DAL as .cs file.

Background

The Setting menu available in the application allows you to set Prefix and Suffix of variables and properties that are generated in the application automatically.

Using the Tool

  1. Paste your Oracle Connection string and Click the Set Connection String Button, which will show you all the procedures of the current schema.
  2. Select the procedure you want to make DAL and Entity layer for and click the Get Parameter Button. It will show you all the parameters with its DataType and Input/output type.
  3. Select the parameter for which you want to create properties and OracleParameter Collection. (You can select all parameters by clicking Toggle All link.)
  4. Click on Make Entity and you will get your complete Entity layer class. In the same way, you will get your DAL also, you can store it as .cs file.
  5. You can set Default Namespaces and class name from Setting Menu.

Points of Interest

Get happiness out of your work or you may never know what happiness is.

- Hubbard Elbert

History

  • 5th November, 2007: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Govind Bhanushali
Software Developer (Senior) Trigyn Technologies Ltd.
India India
Govind Bhanushali
Analyst Programmer
 
Make a difference today. Smile | :)

Comments and Discussions

 
GeneralMy vote of 1 Pinmemberazeez9122-Feb-10 13:37 
QuestionCan it do packages? Pinmemberdatavalue1-Jul-08 23:06 
QuestionCan give sql connection string to Your application? Pinmemberdo ly viet hung6-Nov-07 14:54 
AnswerRe: Can give sql connection string to Your application? PinmemberGovind Bhanushali6-Nov-07 21:28 
GeneralDon't use bold text PinmvpColin Angus Mackay5-Nov-07 23:51 
GeneralCrap again Pinmembernorm .net5-Nov-07 22:48 
GeneralRe: Crap again PinmemberSudhir Mangla5-Nov-07 23:08 
GeneralRe: Crap again Pinmembernorm .net5-Nov-07 23:15 
GeneralRe: Crap again PinmemberGovind Bhanushali6-Nov-07 4:05 
GeneralRe: Crap again Pinmembernorm .net6-Nov-07 4:12 
GeneralRe: Crap again PinmemberSudhir Mangla6-Nov-07 6:06 
GeneralRe: Crap again Pinmembernorm .net6-Nov-07 21:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141223.1 | Last Updated 6 Nov 2007
Article Copyright 2007 by Govind Bhanushali
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid