Saturday, September 23, 2006

BLINQ! Web-Application generated

BLINQ is a scaffolding tool, available from the ASP.NET Sandbox Platform.
In this post, I'll try to explain details about BLINQ, especially

  • the idea
  • architecture and code generation
  • the webforms
  • summary

Idea

With the command line tool BLINQ, you can generate a Web-Application on the basis of an exisiting database schema. The resulting application does allow managing the data: select, insert, update and deletes. The relations between the data are used for navigation purposes and for foreign-key lookups.

So the idea is not really idea, but powerful in combination with ASP.NET. Let's see....

BLINQ is an abbreviation for WeB Language INtegrated Query, according to the naming pattern BLOG (WeB LOG). LINQ, the upcomming technology for universal, next generation data access is responsible to query and save the data thru objects. More details about LINQ, you will find on Scott's Blog and inside the official Linq Project Page.

Architecture and Code Generation


(Click the image to enlarge)


Step 1:


BLINQ needs database schema metadata (what a surprise :-). With the LINQ May CTP, the command line tool SQLMetal is installed, which is internal used by BLINQ to generate the necessary information and general data access classes.

For example, you can call SQLMetal manually to get metadata as xml:

sqlmetal.exe /server:.\sql2k5 /database:northwind /xml:northwind.xml

The resulting file looks like this (this is just the fragment for the northwind category table):


An other way to call SQLMetal:

sqlmetal.exe /server:.\sql2k5 /database:northwind /xml:northwind.cs

The result is a complete data access via LINQ (here's an other fragment):

Step 2:

After generating the general data access thru SQLMetal, BLINQ does generate more specific methods to query and update the backend. These methods are located inside the file StaticMethods.cs. If you call BLINQ with the parameter /pageDataSource, this methods are generated direct into the code-beside files.

Step 3:

The last step: BLINQ does generate WebForms, according the meta informations. For each table inside the database, BLINQ does generate three forms:

  • TableName.aspx
    A list of all records (GridView) including sorting, paging, navigation, editing and deletes.

  • NewTableName.aspx
    A single record view (DetailView) to add new data.

  • TableNameDetail.aspx
    A single record view (DetailView) to edit the data.

As an other example, the northwind tables "Customers" and "Orders" (parent-child relation) are visualized here:


The resulting forms and navigation here (technical view):


WebForms

Here you can see Order Detail WebForm, generated by Blinq:

BLINQ does profit from the new ASP.NET 2.0 components and mechanism:
  • Layout is styled via MasterPage and Theme
  • Navigation does use Menu Control and SiteMap
  • Breadcrump thru the SiteMapPath Control
  • List with the GridView Control
  • Single Record with the DetailView Control
  • Business Object are accessed thru ObjectDataSource
  • Page methods thru the new PageDataSource

This fact is great and brings the advantage, that we can use your existing skills and knowledge of ASP.NET to customize the generated forms. By just changing the theme a bit and by changing the Employee Dropdown Fields DisplayValue, you can get the following customized result:


Summary

The first BLINQ Preview is available since June 06.

Naturally, there are several features missing in the current version, e.g. :

  • No validation inside Grid- and DetailView (e.g. required fields, validator according data type)
  • No editors (e.g. for DateTime fields)
  • No Ajax Support
  • No Designer Support
  • Limited templating
  • "Just" SQLServer 2000, -2005, -2005 Express Support

Polita Paulus, THE BLINQ Developer, is an active poster at the BLINQ Forum. She is responsible for the GridView, DataView and FormView ASP.NET as well.

BLINQ is useful for

  • prototyping
  • web-based data-table administration
  • as a starting point for more complex application
  • learning ASP.NET 2.0

The combination "robust and complex Web Framework (= ASP.NET)" with "Code Generation" is powerful. I looking forward to the next release.

14 comments:

Anonymous said...

Hi!

I linked this post from the BLinq section in NetFXGuide. Please feel free to add new resources that you might have through the form on that page.

Best,
Francesco

Anonymous said...

Patrick- this is a great summary of the Blinq architecture. Thanks for dedicating an entry to Blinq, and for the suggestions on what future features you're most interested in.

Anonymous said...

In preparation for the purchase of a tennis racquetbefore, we must consider your financial ability to bear; On this basis, a further comparison, as far as possible, choose your tennis racket. Now a lot of cheap tennis racquet and more mixed materials, the proportion of mixed-use to control the stiffness of the tennis racquet discount and the shock-absorbing capacity, the more rigid cheap tennis racket, the swing more powerful force; but the relative resilience of the shock-absorbing capacity and discount tennis racket performance of talks on the easier it is for the wrist and elbow injury.
head junior tennis racket
wilson tennis racquet
wilson tennis racket
head tennis racket
babolat tennis racket
Womens Handbags
Cheap Purses
Designer Handbags

Anonymous said...

Burberry polo shirt the steady, solid, so many young girls also love it. Speaking of people of a ralph lauren polo, think it a sign of nobility elegant waving in the horse club.spyder jacket in the cold in your winter activities can be easily.columbia jacket it is expensive, but here you do not need to consider the price of it. the north face jacket one of my favorite money, I do not know how many in this world of its fans.
ed hardy clothing
ed hardy clothes
ed hardy shirts
ed hardy t-shirts
ed hardy sunglasses
ed hardy mens
ed hardy womens
Wholesale Handbags
Cheap Handbags

Anonymous said...

China Wholesale
wholesale from china
buy products wholesale
China Wholesalers
burberry polo shirt

Anonymous said...

cosplay costumes are in hot sales. These wholesale costume can be bought in our cosplay online store. Wholesale anime cosplay costumesand naruto cosplay costumes at discount price. I love everything and I was wondering how I could make a Japanese School Uniform. You'll need cloth of course probably navy or white for the majority. Costume of Final Fantasy Cosplay, Bleach Cosplay and Kingdom Hearts Cosplay has a feature article on the Japanese School Uniform fashion. We provide all kins of costumes of cosplay naruto, and these costumes of cheap cosplay are made of high quality materials. As the time flying, more and more youngers like clothing of anime cosplay.

cheap nike shoes said...

Truely a nice blog and thanks for your great work. By the way, welcome to our websites: nike sports shoes and ghd hair straightners. Every men like sport, then, it is quite important to have a pair of right cheap sports shoes to make you fully enjoy the sports. We provide puma cat , cheap nike shox, cheap nike max, shox shoesshoes, nike shox r4 shoes, shox shoes, ferrari shoesrunning shoes which are brand new and in perfect condition but on discount. All of the shoes, including the popularnike tn dollarpuma running shoes, cheap nike shoes,which is the representative shoes of nike mens shoesshoes are authentic and original of top quality. For people like running and playing basketball and other field sports, nothing would be more suitable than the cheap adidas shoes and nike shox nz basketball shoes. In addition to the shoes mentioned above, you may also be interested in the cheap adidas shoes , puma shoes and, nike running shoesWholesale and retail are both acceptable to us. Welcome to our site and free to look! Thank you and wish you a nice day. Good Luck!
Everybody like beauty, which is quite commen, especailly womens. Welcom to our store which is focused on sellingghd hair straighteners mk4and hair straightners. For women, especially the young girls, this ghd iv styler hair straightener is the best choice. ghd hair straightnersis famouse for the pretty outlook and the top quality. The price of this cheap ghd hair straightenersis acceptable and rational. Ed Hardy Jeans, Ed Hardy Hoodies ed hardy shirts ed hardy clothes ed hardy clothing
ed hardy trousers

valves said...

http://www.thehairstraighteners.com/

Unknown said...

Both sides also collectively released a 3 festivities to commemorate the tenth anniversary of cooperation
Nike Air Max Shoes
Nike Air Max 2011
Nike Air Max
Nike Air Max 2009
Nike Air Max 95
Nike Air Max 91
Nike Air Max 87
Nike Air Max 180
Nike Air Max Griffey Max 1
Nike Air Max 90
Nike Air Max 1
Nike Air Max Wildwood Supreme
Nike Air Max Turbulence
Nike Air Max Skyline
Nike Air Max Goadome
Nike Air Max Fitsole
Nike Air Max Zenyth
Nike Air Max Boots
Nike Air Max Zoom Kobe
Nike Air Max Tn
Nike Air Max LTD
Nike Air Max Presto
Nike Air Max BW
Nike Air Max 24 7
Nike Air Max 2010
Nike Air Max 2011
Abercrombie and Fitch London
Abercrombie & Fitch Clothes
Vibram Shoes
Cheap Air Max
Nike Air Max Shoes
I saw peach falling from the window in your house. Walking really happy, to ensure that all of the uncomfortable into simple

silence. I'm the only person who heard one's heart beat.

Unknown said...

The christian louboutin store was designed for the ladies. Since the louboutin heelswas born, the ladies life become colorful.The elegant pattern, the delicate style all mold the ladies perfect leg profile. Thechristian louboutin evening pumps are the god's masterwork. Who invited thechristian louboutin pumps? Seldom people knew, but I think every lady would be grateful for him. Among the countless pumps, the christian louboutin peep toe is the most outstanding ones. Flowers in the spring of 2011 creeping, up from hair to clothes continue to footwear, have had a brilliant up. In such a glamor, spring and summer flowers now here. Romance is a woman's mood, exquisite flowers just right of expression in our gestures, the woman, how can we not love the romantic temperament so that they distributed the flowers do? 2011 flowers bloom will enjoy different poses! The Christian Louboutin 2011 Sandals also can adds the hright of the ladies, it bring surprise to the short lady. Especially the red sole of the louboutin heels, magic and sexy, many ladies are crazy. The red sole, the first feature of the Christian Louboutin heels.

jelish said...

Christian Louboutin Outlet Online Store offer 2011 new-style Christian Louboutin Sale Outlet online store.We will provide you with all kinds of CL.The Christian Louboutin Ankle Boots serve different functions and keep your feet stylish and warm,Christian Louboutin High Heels can always show our body in the best charming way, making her legs look as long as possible.Christian Louboutin New Style are the best choice for you to choose the brand, especially you want to keep steps to the fashion world.Christian Louboutin Peep Toes that are considered as classic due to the fact they are comfortable.Buy cheap Louboutin Outlet shoes, get your favorite.
http://www.christianlouboutinoutletonline.org

London Escort Agency said...

Your Escort Agency offers exclusive and most beautiful London escort girls of various nationalities.

London escorts said...

Bestescort4U agency provids best London escorts companionship in the UK.

fix credit said...

interesting blog and post, thanks for posting.