C# Code generator that can speeds up the development of a DB driven software?

Question

Hi,

I'm new to c# and .net development. I'm looking for a C# code generator that can generate the code for CRUD operations and entity objects against tables in a database. It needs to be:

Support Oracle database; The generated code must be simple and easy to use.

Thank you very much in advance!

Answer 1

• Entity Framework with an Oracle provider
• NHibernate
• LLBLGen Pro
• DbLinq (like LINQ-to-SQL)

Answer 2

Check out CodeSmith for generating code from Oracle. It should support generating the files to be used by frameworks such as .netTiers, nHibernate etc.

Answer 3

I think what you are looking for is a ORM tool. There are a number of ORM tools on the market, Some are open source projects while others are large scale commercial products.

Here's a list of .NET based ORMs that supports Oracle that I have heard/read/used:

DataObjects.Net

Nhibernate

SubSonic

Answer 4

MyGeneration is a popular code generator for data-access. I believe it has an oracle template(s):

Answer 5

I definately agree that you should be looking at/for an ORM product. In addition to those already mentioned I would bring up Telerik's Open Access. It covers a good number of databases and integrates well to a number of other Microsoft technologies.

The down side is that it isn't free. But in my case our company purchased it in a package with controls. We needed to purchase a set of controls for a Silverlight project. I sold the boss on purchasing their suite as if we ever needed controls for either WPF or WinForms it would be paid for. They have a suite that contains controls for just about any .NET project along with their ORM and reporting.