Awesome Code generation !!!!
Have a look at MyGeneration. ( Click the link !!!!!!!!!!!, don't miss out..... )
This is a freeware code generation tool that really works.....Normally I use the NorthWind database to test code generation and I test it in VB.Net and C#. Usually I have to modify stuff on some points to get the stuff working.
And now I came across this beauty !!!!.
Really try it...... !!! ..............There are several supported architectures but the best (until now) is the dOOdad architecure... (Yes click the link to see what it is...........)
I think it is really awesome..... I just pointed it to the NortWind Database and it worked at once.....
If you are interested in productivity tools have a look at it.
Oh yes and the beauty of it all.... It is all NATIVE .Net.... Not an ugly unknown DLL somewhere NO... everything is compiled. You only have to add a referrence to the dOOdad project.
Ok..... so far I told you to go and visit the website ....Here are some reasons why........
Very easy dynamic queries.........
Dim
emps As New Employees
' LastNames that have "A" anywhere in them
emps.Where.LastName.Value = "%A%"
emps.Where.LastName.Operator = WhereParameter.Operand.Like_
emps.Query.Load()
or
Dim emps As New Employees
' LastNames that have "A" anywher in them
emps.Where.LastName.Value = "%A%"
emps.Where.LastName.Operator = WhereParameter.Operand.Like_
' Only return the EmployeeID and LastName
emps.Query.AddResultColumn(Employees.ColumnNames.EmployeeID)
emps.Query.AddResultColumn(Employees.ColumnNames.LastName)
' Order by LastName
' (you can add as many order by columns as you like by repeatedly calling this)
emps.Query.AddOrderBy(Employees.ColumnNames.LastName, WhereParameter.Dir.ASC)
' Bring back only distinct rows
emps.Query.Distinct = True
' Bring back the top 10 rows
emps.Query.Top = 10
emps.Query.Load()
Easy Iteration
Dim emps As New Employees
If emps.LoadAll() Then
Dim lastName As String
' Iteration walks the DataTable.DefaultView, see the FilterAndSort
' sample for further clarification.
Do
lastName = emps.LastName
Loop Until Not emps.MoveNext
emps.Rewind()
Do
lastName = emps.LastName
Loop Until Not emps.MoveNext
End If
Easy Bulk Update
Dim emps As New Employees
If emps.LoadAll() Then
' Modify the LastName column in every row
Do
emps.LastName = emps.LastName + "W"
Loop Until Not emps.MoveNext
' Rewind and mark the first row as Deleted
'emps.Rewind()
'emps.MarkAsDeleted()
' Add a new row and fill it in
emps.AddNew()
emps.FirstName = "Jimmy"
emps.LastName = "Lunch Box"
' Save all modifications, deletes, and new rows
emps.Save()
End If
And there are many many more templates based on the dOOdad architecture... Even screens are generated automatically !!!!!