Tuesday, March 22, 2011

Microsoft SQL Server Migration Assistant

Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.

See writers blogs here and download it for:
Oracle
Access
MySQL

Sunday, March 20, 2011

EF 4.1

As you now last week Microsoft release new version of the EF(4.1), you can download it here.

Based on our experience we normally start to developing projects from designing and creating a database, but this way has some problems.

the biggest problem is that when we start to design classes and objects in the code part of project, our classes will be so similar to tables and we normally do not use great features of OO design like inheritance and ...
another issue is that there are many developers that don't have enough knowledge about database and database design rules like normalization so it's hard for them to design a database.

but new version of the EF(4.1) support Code-Base design. what does it mean? it mean that you can design your classes, your UI and all part of your application without even creating a table.you application will start to work, without any table,view,sp or any other issue related to database.

obviously, if you want to save your data you need to have a database, that's not a problem you can ask EF to do that for you ;-).

ScottGu's as always has great post about this issue, he redesign his NerdDinner application using this new EF ability, do not lose it.

Sunday, March 13, 2011

SQL Server Compact 4.0

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites ,Windows desktop applications and mobile devices.

Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition. The latest release is the SQL Server Compact 4.0 supporting .NET Framework 4.0, and dropping support for Windows Mobile in this release.

You can download it from this address and its book online from this address.

Friday, March 11, 2011

Visual Studio LightSwitch

Tonight I watched some videos about Visual Studio LightSwitch,actual I have a very mixed sense about it.
from one point of view it is just an advance form maker, the better version or advanced version of Microsoft Access form maker that will not be so successful, I mean it remembers me the Microsoft Dynamic Data framework, that no body in the real world will use that.
but on the other hand, it has some cool features, it can connect to different data source(like SQL, SharePoint,...), you can simply create the data entry forms, report & search frorms and ... that are so useful for the people which are not professional software developer but like to write small application.

take a look on the Microsoft videos about this and say your views about it too me.

Monday, March 7, 2011

Accessing Server-Side Data from Client Script: Accessing JSON Data From an ASP.NET Page Using jQuery

Many times I was thinking about issues like: check the user-name availability before user click on Submit button, or master-detail Senario before post back.

this is a cool post by Scott Mitchell which wrote great ASP.NET Data-Access tutorial for ASP.NET site.

The current article is about Accessing Server-Side Data from Client Script using JSon and JQuesry. link

Sunday, March 6, 2011

WPF Developer Training Videos

I know Joe Stagner since 3-4 years ago, since he started to post some videos about ASP.NET.

he gather many cool videos about WPF and share link to them in his great web-log.

do not lose them ;-).

WPF Developer Training Videos