LLBLGEN pro

[Guest]

has anyone used LLBLGEN pro for real apps
i have tried it a little and it seems like gods gift but i would like to hear other peoples opinion

cheer

gu

ps how do you persuade your dbas that its ok not to use stored procs?

 

[Colin Young]

I have been using it since the original open source and I am now using the
commercial version. I have a website running on the original code and I'm
completing a "real" application with the latest version. I wouldn't want to
work without it again.

Persuading the dbas wasn't too difficult since I'm the dba. It depends on
what they are using SPs for. If they are for performance, if you are using
SQL Server 2000, that isn't a big deal any more. If it's for security, that
could be a bit more of a difficult sell, although if you are using 'sa' or
dbo to connect to the database, I think you've got a good argument that
there isn't any security anyway.

Colin

 

[William Ryan eMVP]

LLBLGen Pro is VERY suitable for 'real' apps. I've used both it and
Deklarit and think they are both first rate products. We have an ORM forum
over at Devbuzz and my friend Derek who started devbuzz uses it for
everything right now.
http://forums.devbuzz.com/Using_OR/M_and_Code_Generators/forumid_28/tt.htm
.. The stored proc issue isn't that big of a deal b/c parameters are
generated so that takes much of the risk out of dynamic sql out of the
equation. You still need to grant more permissions but Stored procs aren't
always feasible (although I try to use them as much as possible). Ask Derek
any specific questions though, he's used it a bunch and now uses it
exclusively for his data access stuff.

HTH,

Bill

has anyone used LLBLGEN pro for real apps?
i have tried it a little and it seems like gods gift but i would like to hear other peoples opinions

cheers

guy

ps how do you persuade your dbas that its ok not to use stored procs?

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp

 

[Frans Bouma [C# MVP]]

has anyone used LLBLGEN pro for real apps?
i have tried it a little and it seems like gods gift but i would like to
hear other peoples opinions

It's been used for over a 100 very large scale applications already
(100-1000 tables or even more). Thanks for the compliments

ps how do you persuade your dbas that its ok not to use stored procs?

THis can be a hard case, but most concerns of DBA's are related to a couple
of things:
1) speed
2) security

1) is not an issue as all SQL is generated with parameters and all SQL is
build to do just as little as what's required and taylored towards the task
to perform. Parameterized queries are cached as stored procs, there is no
difference in that
2) security is not an issue either, as you can still use views/procs if you
like for sensible data (views are read-only), just not the entities with
procs. Futhermore, security is not something that comes with 'stored
procedures', but with correctly applying role based security in SqlServer for
example. If your DBA has any questions, please send them to us, we're happy
to help you Use: support at llblgen dot com

Frans.

 

[Guest]

Thanks Frans, I totally accept your point about speed and security, the problem I tend to find is that use of SPs has become dogma. Most dbas I query this with in effect say 'you must use SPs because you must'

I will definitely be using LLBLGEN pro though, the time savings are phenomenal even on my test system
cheer

guy

 

[Frans Bouma [C# MVP]]

Thanks Frans, I totally accept your point about speed and security, the
problem I tend to find is that use of SPs has become dogma. Most dbas I
query this with in effect say 'you must use SPs because you must' !

Yeah, tell me about it.
I once wrote an article about these dogmas:
http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx

139 reactions and counting

I will definitely be using LLBLGEN pro though, the time savings are
phenomenal even on my test system. cheers

Thanks for the feedback!

Frans

 

[Guest]

What an article:-

whenever you can remove code you remove potenial bugs, so if you remove a complete layer..

guy