Code generator for DAL:
- Head over to Codeplex
- Download Subsonic 2.1
- Install. No GAC. No add-ins.
- Settings in web.config
- Uses ActiveRecord pattern; 80% of the projects are light-weight, doesn’t use Enterprise patterns
- “I want the developer to go home early”
- Industry strength: can it scale? No?
- nHibernate is excellent at; caching; future query;
- Generally, start with DB; build out your model;
- Migrations can generate database for you. (Define class in .NET code first.)
- Command line tool that can (Sonic.exe AKA Subcommander) generate DAL.
- Use typical repository pattern (returns IList of )
- Generates ANSI-SQL for multiple Database Standards
- LLBLGEN Pro: pocket book constraint; blows doors over Subsonic’s functionality; but it’s edge-case stuff;
- nHibernate: complex to implement;
- Subsonic: for people who aren’t into the tinkering of creating a web site; pragmatic
- example: Subsonic Starter Site (Dot Net Nuke ultra-light); no longer supported
Other related posts:
Teach Yourself Azure in 4 hours
Geek Post Monthly Newsletter Volume 2 Issue 10
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.
JamesHip's profileJames Hippolite
Welcome to my technical blog.
Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996. This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog. But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".