What is Llblgen?
It is a tool that generate data access layer from your database . Thus, saving developer time you on writing CRUD (create, retreive ,update, delete) code in the .net framework.
Feature list:
- Multiple databases support. MsSQL, Oracle, MySQL, MS Access and etc
- All .net framework version support. This include compact framework.
- Most database access operation is supported. Table record operation, retrieve views and store procedure execution.
- Linq is supported.
- DAL supports both desktop and window application development.
I am still not impressed, who is using it?
Check the company list here
Read more about Llblgen Pro
Saturday, September 05, 2009
Where to download Northwind database?
I am working with Llblgen recently. The sample code requires the SQL2000 Northwind database. It took me some time to locate it. Let share the link then:
Download Northwind database samples
The sample installs the samples on 'C:\SQL Server 2000 Sample Databases' folder.
How about just download Northwind sql script?
Here you go . Rename the file to instnwnd.sql after download.
Is the script compatible with other version of SQL server (SQL2005, SQL2008) ?
Yes. Use the instnwnd.sql. Execute the sql script in your SQL Management Studio. The script create the Northwind database schemas with sample data. At least database backup (mdf and ldf) compatibility is least of your problem.
I didn't try the mdf backup restore but did create the db in SQL2008 instance using just sql script. No problem at all.
Happy trying. :)
Download Northwind database samples
The sample installs the samples on 'C:\SQL Server 2000 Sample Databases' folder.
How about just download Northwind sql script?
Here you go . Rename the file to instnwnd.sql after download.
Is the script compatible with other version of SQL server (SQL2005, SQL2008) ?
Yes. Use the instnwnd.sql. Execute the sql script in your SQL Management Studio. The script create the Northwind database schemas with sample data. At least database backup (mdf and ldf) compatibility is least of your problem.
I didn't try the mdf backup restore but did create the db in SQL2008 instance using just sql script. No problem at all.
Happy trying. :)
Subscribe to:
Posts (Atom)