Hi,



Is there any tool that automatically generates code for Data Access
component based on existing database table?



Thanks,

Alan

Visual Studio .Net can do it but Microsoft says- don't use it!! It's
virtually imposible to accurately generate data access codes through some
tools. I know you would not like this answer but that's the reality.

"A.M" <(E-Mail Removed)> wrote in message
news:u4jMz$(E-Mail Removed)...
> Hi,
>
>
>
> Is there any tool that automatically generates code for Data Access
> component based on existing database table?
>
>
>
> Thanks,
>
> Alan
>
>

Thanks for Prodip's quick response!

Hi Alan,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to generate data accessing
code automatically according to particular database table. If there is any
misunderstanding, please feel free to let me know.

I think you mean the DataAdapter's SELECT, UPDATE, INSERT and DELETE
commands in this issue. We can use the DataAdapter Configuration Wizard to
accomplish this. You can drag a DataAdapter object from the toolbox and the
wizard will be shown. We just use the query builder to generate the SELECT
command, and the other commands will be generated in later steps of the
wizard.

If you need to generate the commands at runtime using code, and working on
a SQL server as database, we can also use SqlCommandBuilder class to
achieve this. For more information, please check the following link:

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdatasqlclientsqlcommandbuilderclasstopic.asp

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Prodip Saha wrote:
> Visual Studio .Net can do it but Microsoft says- don't use it!! It's
> virtually imposible to accurately generate data access codes through some
> tools. I know you would not like this answer but that's the reality.

Erm... perhaps your reality, but not mine or anybody elses. It's
perfectly possible to generate data access code from table definitions,
and even generate SQL on teh fly using simple typed query specifications
and meta-data.

Frans

> "A.M" <(E-Mail Removed)> wrote in message
> news:u4jMz$(E-Mail Removed)...
>
>>Is there any tool that automatically generates code for Data Access
>>component based on existing database table?

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

A.M wrote:
>
> Is there any tool that automatically generates code for Data Access
> component based on existing database table?

Depends on which database your tables are in We don't support all
databases yet, but a wide range, so perhaps your database is supported.
Feel free to try the demo: http://www.llblgen.com

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

SQL Server 2005 allows you to specify Query Hints without actually modifying
the Query itself. This however takes into account the fact that all query
plans are cached. Including Dynamic SQL/Embedded SQL.

Now, for such autogenerated queries, or the ones generated on fly, wouldn't
they be at a terrible disadvantage that you couldn't specify hints to them
in advance?

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/





"Frans Bouma [C# MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Prodip Saha wrote:
> > Visual Studio .Net can do it but Microsoft says- don't use it!! It's
> > virtually imposible to accurately generate data access codes through
some
> > tools. I know you would not like this answer but that's the reality.
>
> Erm... perhaps your reality, but not mine or anybody elses. It's
> perfectly possible to generate data access code from table definitions,
> and even generate SQL on teh fly using simple typed query specifications
> and meta-data.
>
> Frans
>
> > "A.M" <(E-Mail Removed)> wrote in message
> > news:u4jMz$(E-Mail Removed)...
> >
> >>Is there any tool that automatically generates code for Data Access
> >>component based on existing database table?
>
> Frans
>
> --
> ------------------------------------------------------------------------
> Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------