.NetFoundry

Super-Speed Internet Satellite Is In Space!!!

Manjula Perera — Sun, 24 Feb 2008 04:29:00 GMT

1.2 GB per second speed in internet browsing for a low cost??? Is it a dream? or Is it science fiction?

The answer is no. Japan's Aerospace Exploration Agency (JAXA) and Mitsubishi Heavy Industries has launched an experimental super-speed satellite into orbit yesterday (0855 GMT) as per CNN and BBC. This would be a mile stone in super-speed data communication over the internet. And it would enable Hi-definition TV broadcasts.

This is still in experimental stage and only available in Japan and 19 other loations in south east asia as per JAXA.

This is grea news for the IT industry as a whole.

References

BBC

CNN

Microsoft SkyDrive - Your Online Hard Drive Is Here!!!

Manjula Perera — Sun, 17 Feb 2008 18:07:00 GMT

Get ready to say good bye to your pen drives, portable hard drives or any other portable mass storage devices. Why? Because Microsoft has launched yet another innovative solution for document management.

Overview

I recently came accross with this fantastic online password protected file storage system by Microsoft and thought of sharing the information with you, the readers of this blog.

Advantages of SkyDrive

This,

Is as mentioned before, an online file storage with password protection
Could access from anywhere in the world where there is a stable internet connection and could modify and share documents without carrying them along wherever we go
Could restrict the file share to the specific people we choose or make them public so the entire world could see them but can't edit them
Could assign access permission to each folder we create
Has 1GB of free online storage
Works with any latest web browser
All file transfers in shared environment is done through SSL (Secured Socket Layer) so the file are secure.

Want to know more?

Visit SkyDrive home page for more information.

References

Microsoft SkyDrive Home

Browser's Refresh Problem & the .NET Solve

Raheel Hussain — Sun, 17 Feb 2008 17:43:00 GMT

A couple of years back, I faced a problem in while doing a web project, that was regarding the browser's refresh.

Although, I managed to solve it as problems are meant to be solved, but that time I was not a blogger.

At the time of writting this post, the time is 21:53 17-Feb-08 and I'm sitting late in my office working on a project and then during my work, it happened to occur again.

The idea was simple and straight forward

Suppose you've a button on your web page, with some code behind, when the button was clicked, it performed some operation (i.e. the code behind gets executed),
now when you press refresh on your web page ( F5 or Ctrl+R), the same code gets executed twice while it shouldn't.

So the solution to this was to capture the the browser's refresh. Following is an interesting post, and hope you'll find it useful.

http://joel.net/code/refresh_capture.aspx

Regards -

I'm 15 days old now MashaAllah

Raheel Hussain — Mon, 11 Feb 2008 06:13:00 GMT

Hot IT acronyms

Azhar Jamal — Wed, 06 Feb 2008 06:07:00 GMT

IT professionals adore acronyms and shorthand. That’s one of the reasons why normal people think IT pros are speaking a foreign language when we talk amongst ourselves. If you want to keep up with trends in IT management for 2008, familiarize yourself with this list of hot acronyms that your fellow IT pros are talking about.

7. BPM

Business Process Management is all about using technology to make business processes more efficient and less time consuming, and thus completing the same processes with fewer resources. In other words, it’s about streamlining operations to save money. Many IT departments and IT service agents — such as IBM — are focusing on BPM as a way to transform the image of IT from a cost center to a value center.

6. CMDB

A Configuration Management Database collects configuration data about the various pieces of an IT infrastructure and stores them in a unified repository that can be systematically analyzed and managed. In this system, the various pieces of data are called “configuration items” (CIs) and the goal is track changes to the CIs and to ultimately auto-discover new items. CMDB is a critical component of the ITIL framework, and it can be an extremely valuable asset for standardizing IT management.

5. BI

Business Intelligence is a fancy name for the high-powered reports and dashboards that smart companies use to track the performance of their businesses. For example, “BI is the way you get ROI out of ERP.” What he’s getting at is that BI is what gives full value for the hard work of implementing an ERP or data warehousing project, because BI allows you to mine the data to better understand the trajectory of your company.

4. MDM

Master Data Management is the new buzzword for unifying data sources to provide a single, reliable source of information about customers, products, employees, and other assets. This may sound similar to data warehousing (DW), but it’s actually bigger. While DW is mostly about unifying backend log files and tracking data in order to produce reports, MDM is about unifying critical business data that are typically live and dynamic, such as customer and product data.

3. TCO

Total cost of ownership is a phrase coined by the Gartner Group in 1987, and it has developed into a useful formula for arriving at the full costs involved in deploying and managing technology tools. TCO calculations provide assistance with product selection, because they are a valuable part of estimating return on investment (ROI). With tech budgets tightening in 2008, TCO and ROI will become even more critical in helping IT departments decide how to best spend their constrained budgets.

2. SOA

Service Oriented Architecture has a few distinguishing characteristics, but it’s the same type of cloud computing that has been referred to as “Web services” and “Software as a Service” over the past decade. The difference with SOA is that it goes a step beyond cloud computing by breaking down software services into standard building blocks that can be re-used, distributed, and fed into other sites, programs, and projects.

1. ITIL

Information Technology Infrastructure Library has evolved into a set of standards and best practices for organizing and running an IT department. Originally developed by the British government with inspiration from IBM, ITIL is now an international phenomenon and a hot commodity in the United States, where ITIL-trained professionals are in strong demand. ITILv3 was published in April 2007, and one of the most important revisions was a stronger alignment between IT and business — another critical theme for IT in 2008.

Thanks to Danish & Raheel

Azhar Jamal — Wed, 06 Feb 2008 05:57:00 GMT

I would like to appologize that for a long time I was not able to start writing blog and not even thanks to Danish & Raheel, who actully remind me time to time to start writing.

Thanks Mr. Danish and Mr. Raheel.

Microsoft Web Deployment Tool Is Here!

Manjula Perera — Sun, 03 Feb 2008 06:59:00 GMT

Good News for ASP.Net Developers

This is yet another exiting development by Microsoft. I just came across with an article about this tool in the IIS main web site and thought of sharing the information with the readers of this blog.

Overview

Last week Microsoft has launched the Microsoft Web Deployment Tool as a Community Technical Preview (CTP), which provides deployment and migration support for IIS versions 6.0 and 7.0. This tool incorporates many features that enable web server administrators to deploy, sync and migrate websites, including configuration, content, SSL certificates and other types of data associated with a Web server.

This tool can be used on Windows Server 2008 and Internet Information Services 7.0 as well as Windows Server 2003 and Internet Information Services 6.0.

Features

Provides administrators with a way to quickly synchronize a site or server and deploy changes to existing sites and servers
Provides administrators with a way to migrate sites or entire servers from IIS 6.0 to IIS 7.0, including their settings and content
Allows administrators to check what components are installed on the source server. I.e. to check what components to be installed or requirement to have an advanced installation in IIS 7.0
Troubleshooting and Validation Features

Support

For support in this tool please refer to the support forum, or download the documentation here.

Requirements

The following prerequisites must be fulfilled in order to install the tool:

You must be using Windows Server 2003 or Windows Server 2008.
The .NET 2.0 Framework SP1 or greater must be installed.
Internet Information Services 6.0 or 7.0 must be installed in order to perform operations on IIS.
You must install the tool as an administrator. If User Access Control (UAC) is enabled, you must use the “Run as Administrator” option when installing.

Download

You can download the Microsoft Web Deployment Tool here.

References

IIS

ScottGu's Blog

Blog By My Newborn Daughter

Raheel Hussain — Sun, 27 Jan 2008 10:25:00 GMT

Choose the right connection string for your data source!

Manjula Perera — Sun, 20 Jan 2008 06:23:00 GMT

Hi friends! I thought of sharing this URL with you all where I usually get information about connection strings. This has been a reference site for me on various connection strings for several years now. It's a great site where it gives a collection of connection strings for most of the databases servers, data files and other data sources in one place. And it gives connection strings for different scenarios (ODBC, OLE DB etc) for the same data source as well.

Check it out.

http://www.connectionstrings.com/

.NET Framework Library Source Code Released

Raheel Hussain — Thu, 17 Jan 2008 05:32:00 GMT

Guys ....... Check this out

Written by Shawn Burke of Microsoft...

It's finally here - the launch of the .NET Reference Source project. This post (hopefully!) contains everything you need to know. Over the past few weeks, we ran a pilot of this feature and collected lots of great data that helped us work through some issues and understand where people were likely to have problems.

Please carry on with he following link

http://blogs.msdn.com/sburke/archive/2008/01/16/configuring-visual-studio-to-debug-net-framework-source-code.aspx

More on Scott's Blog

http://weblogs.asp.net/scottgu/archive/2008/01/16/net-framework-library-source-code-now-available.aspx

And Scott Hanselman's ComputerZen.com

http://www.hanselman.com/blog/NETFrameworkLibrarySourceCodeAvailableForViewing.aspx

Regards

ASP.NET with Google Checkout - Part 1

Raheel Hussain — Tue, 15 Jan 2008 05:45:00 GMT

Google Checkout is a fast and easy solution for online Buyers and Sellers, and getting popular vert fast.

Recently, I had a chance to integrate the google checkout with one of a website I developped.

The site is already integrated with the Local Mashreq Bank Merchant Account of UAE, for local UAE sales.

The sales for the international customers however, became a bit issue because of conversion from EURO/GBP/USD$ wasn't the good option at all and caused a drop in sales.

This led them to think of a solution which would encompass both local as well as international market sales. It was fun as well as a good exposure for me.

You can Visit : http://www.1boxoffice.com/

I thought to state down what i've experienced and learnt with it, to help out other developers going to do the same in future.

How Google Checkout Works

Google checkout has following different distinct ways of integration

Third-party e-Commerce Provider - i.e. 3rd Party Shopping Carts
A Simple HTML code for Non-eCommers Plateforms
Google Supported e-Commerce Providers
Customized e-Commerce Plateform i.e. Microsoft Commerce Server, IBM Websphere, (or may be your own custom made Shopping cart)
Sending Invoices through Email.

I'm not going to cover all the options, since the site I did best fits with option #4, which is A Customized e-Commerce Plateform.
I Shoping Cart on the site was custom developped by me.

Under this option, Google provides two different set of APIs

Google Checkout HTML API
Google Checkout XML Developer API
with Order Processing, Order Notification, and Merchant Calculation separate APIs respectively

Since, I had to implement the Order Processing as well as the Order notifications, I chose Option-Two the XML API method.

Note:
The HTML way is even simpler, as this method includes the form hidden variables which are to be posted to the Google Payment Server view the Form Post method. The HTML API is limitted in a way that this is only a one-way integration with Google Checkout system, while comparing with the XML API, it provides a veriety of different tracking and integration options ... discussed below.

You can findout details from the following URL :
http://code.google.com/apis/checkout/developer/google_checkout_html_api.html

Google Checkout XML Developer API

The Google checkout API consist of the following separate sets of APIs.

Checkout API - You can send the Shopping Cart Details to the Google System, additionally you can send discounts, VAT, Shipping Charges etc.
Merchant Calculation API - This means that you provide your order calculation rules to Google for the order, and to implement this API, you must create a web service that calculates these values.
Notification API - By implementing this, your system (website admin) will get notified with, Payment approved/disapproved, order processed/shipped and the customer information such as billing telephone, address etc.
Order Processing API - lets you integrate Google Checkout with your internal order processing systems by allowing those systems to automatically send updated order information to Google.

Further details could be foundout through the following URL.
http://code.google.com/apis/checkout/developer/index.html

Note:
When you sign up for a Google Merchant Account, you are given two options for either signing up for a Sandbox Account , which is basically a Test Account, and allows you to experiment your code in the Test Environment, as well as the Production Account, which you'll have after you go Live with Google Checkout.

Hope that this information was good enough to give a quick general overview Google Checkout API.

My next post, I'm going to write about the steps which you've to perform to enable google Checkout in your application.

Happy Coding ........................

Great Website, Must check this out !

Raheel Hussain — Wed, 09 Jan 2008 23:10:00 GMT

Hi Folks !

Checkout this great website designed by Omer Al Zabir sometime back.
Omer Al Zabir is from Bangladesh, and he is Microsoft MVP and MCAD, MCSD Certified.

Initially posted by Joe Stagner of Microsoft, on his Blog, as well as this appeared in ASP.NET home page excerpts...
Below is what he had to say.

Joe Stagner:

I came across Omar Al Zabir's website which he built several years ago.

It's a Windows 2000 UI in the browser.

As we extend our web applications with AJAX, Silverlight, etc. I found this a great reminder of how far you can go with HTML & JavaScript when we really wrap our heads around them and exercise some creativity.

Cool work Omar !

http://omar.mvps.org/

Cheers !

HttpCompression with ASP.NET

Raheel Hussain — Mon, 07 Jan 2008 12:27:00 GMT

Hi,

I came accross a very good article and have already implemented it in couple of my projects in the company.
As I was working on reducing the size of ASP.NET page, thought this is really worth sharing.

Regards - raheel

http://www.codeproject.com/KB/aspnet/HttpCompressionQnD.aspx

Volta - Get Electrocuted with Visual Studio 2008!

Manjula Perera — Mon, 07 Jan 2008 04:50:00 GMT

Microsoft dudes, slow down! We can't keep up!!! But I'm glad you're trying to reduce the "New Stuff" we have to learn by putting forward this project

Overview

Hot news! This is not about Alessandro Volta. This is something Microsoft has released code named Volta. On December 05th 2007 Microsoft Live Labs has announced about VOLTA. Yet again another new term for our geek vocabulary (but they might change it in future)! Volta, as the name hints it's nothing to do with electricity But I think they are trying to equate it's super fast development cycle to an electric current or trying to bridge the gap between distributed bits and pieces of a distributed web application using a spark/ tool.

Volta is a new set of tools developed by Microsoft to develop distributed multi-tier web applications super fast or may I say, with a minimum learning curve using the existing set of .Net tools. I just came across with this information while surfing the internet and reading through blog entries by the peers in the .Net community. Then I started digging into more information. I would like to share what I've learnt with the users of the user group and the readers of this blog. I'll start with an introduction as usual.

What is Volta?

Developed by Erik Meijer (who has also worked in the LINQ project) and a team of developers @ Microsoft
Used to democratize the internet cloud. What??? Watch and learn!
As I said in the overview Volta is a new set of web development tools developed by Microsoft to develop distributed multi-tier web applications with a minimum learning curve using the existing set of .Net tools, techniques and design patterns without incorporating mixture of technologies, languages and tools.
Tier (execution context) splitting (another new geek term!) system where the details of the tiers aren't of primary importance
Much more than a web technology
This is yet a Community Technical Preview (CTP), it'll take time to get adopted to the .Net web development community. But Volta is going to be a revolution in .Net world and the way we build web applications using .Net compatible languages like C# and VB.Net in future. Therefore it's a must we keep track of the developments around Volta and have some hands on experience. We can download the Volta toolset by clicking on the link shown below
Extension to Visual Studio 2008 and .Net framework 3.5 (and most probably for all above versions to come)
We can postpone the multi tier architecture of the distributed web application till the last critical moment of the development process. I.e. first, we can design and build our application as a .NET client application (single-tier application), then assign the portions of the application to run on the server and the client tiers late in the development process (Tier Splitting). I.e. letting the complier manage creating boilerplate code such as communication between tiers
The compiler will create cross-browser JavaScript for the client tier, web services for the server tier, and communication, serialization, synchronization, security, and other boilerplate code (redundancy of code) to tie the tiers together
We can still debug and test the application, as if it were still on the client-tier, because Volta's tier-splitting is deeply integrated with Visual Studio 2008 and the .NET Framework 3.5
We can target either web browsers (be it IE or Firefox) or the CLR as clients and Volta handles the complexities of tier-splitting. We don't need to worry about that
Comprises with tools such as end-to-end profiling to make architectural refactoring and optimization simple and quick
We may base tier assignments on any criteria, such as load management, performance, or location of critical assets and capabilities. Because Volta automates the hidden linking code, it is easy for us to experiment with varying assignments of classes and methods to tiers
We can use all the .NET languages, libraries, and tools we already know, including debuggers, profilers, test generators, refactoring, and code analysis tools to develop distributed web applications. Volta will handle the rest

Learn more

There are lot of study material and sample code to start with at Volta home page. Go and grab them.

Summery

Volta extends the .NET platform to distributed software and services applications, by using existing and familiar libraries, languages, tools, and techniques without the need to learn new technologies, languages and usage of tools to bridge the communication gap between distributed code/ Objects.

Download Volta now and get electrocuted!

Coming Up!

An article about Tesla my hero! Get ready to be electrocuted again

References

Volta home page

View introductory video by the creators of Volta - Part 1 - Erik Meijer and team @ Channel 9, MSDN

View introductory video by the creators of Volta - Part 2 - Erik Meijer and team @ Channel 9, MSDN

Erik Meijer's home page @ Microsoft

Erik Meijer's article about Volta - pdf document

About Erik Meijer - by QCon

About Erik Meijer - by Alex Barnett

Erik Meijer talks about LINQ

‘Volta’: Microsoft’s dev platform in the Cloud? - by Mary Jo

Beware with debug="true" in Web.config file of an ASP.Net web application

Manjula Perera — Sun, 06 Jan 2008 08:26:00 GMT

Problem

I thought of sharing this information with the users of the user group and the readers of this blog. I just came across with an odd situation in my enhancement project developed in ASP.Net 1.0. (As usual)

The problem was that I compiled the project in the "Debug" mode and it went through rigorous testing and life was good. But, later on I noticed that I compiled with "Debug" mode and changed back to "Release" mode and re-compiled the application. This is because if we use debug="true" in our production (live) application it will perform less efficiently than when we use debug="false". See below comments of a sample Web.config file.

</httpModules>

If you need further clarifications on why there's a performance issue please refer to the following article by experts in the industry because this article is about a different scenario related to these settings.

Beware of deploying debug code in production - by Milan Negovan

Don’t run production ASP.NET Applications with debug=”true” enabled - by Scott Guthrie @ Microsoft

Ok back to the problem. Then after this change one of the pages that retreive data from two databases start giving "Request Timed Out" error. This page normally takes more than two minutes to retrieve data. Again if I set debug="true" and re-compile this page wouldn't give any errors. It's wired. So I sort help from good old friend Google.

Solution

When I searched Google I found many people has faced the same issue way before than me (see references). According to the replies in these forums I realised that we just need to add the following tag within <system.web> </system.web> tags. E.g

<system.web>

............

</system.web>

References

DevX Discussions

Velocity Reviews

Microsoft Launch Central

Manjula Perera — Sun, 06 Jan 2008 05:53:00 GMT

Microsoft Launch Central

I just heard about this website where we can keep up with the latest product releases by Microsoft.

Take a look at it

Congratulations for the 2008 MVP Award

danish.sami — Sat, 05 Jan 2008 07:12:00 GMT

This year I've been awarded as an MVP, Windows Server System - SQL Server in continuation with the previous year.

I waited for the whole day and finally by the end of the day I received an email stating that I've been awarded with a lot of appreciation towards my work last year. Its really a motivation factor to work towards the next year and help educate developers with up-to-date technology and tools.

Thanks to Allah for giving me such an oppertunity to work and to get rewarded.

Bandagi!

Working with AJAX - Part 2 - Speed & Page Size

Raheel Hussain — Thu, 03 Jan 2008 07:22:00 GMT

The Purpose of the AJAX (as also discussed by many writters and many websites) is to improve the user experience, as well as client centric operations and development. Instead of fetching the entire page contents, or displaying a completely new page, AJAX enables browsers to fetch and update/alter particular sections of page through the HTML, XML or through Javascript.

I launched my website all full with AJAX, though a very simple one, but it appeared to be very expensive in sense of it's loading time as well as data size.

I received couple of comments on my Guest Book as well as some of my collegues verbally told me of reducing the page load time, for atleast the home page.

Since then, I started doing my research on particularly reducing the page size and then in general, the appropriate combination of AJAX.

Consider the following general Scenario for your website size and images : -

Bigger than 60k in size : Your visitors will be unlikely to wait around and see your homepage.
50k to 60k : You visitors may see your first page, but may wary to wait and see second page.
40k to 50k : Better, but you may still loose visitors.
30k to 40k : Absolute, largest and serious sites would be.
20k to 30k : Responsive, and likely to get second visit.
10k to 20k : Very responsive and a pleasure for your visitors.

Obvisouly! my website had gone above 500k and it was Huge difference, and to make it shorter upto the mark, lots of changes were required.

Since the HomePage of your web-site is considered as a Gateway, that would lead you to the ( text and graphics based ) content. If the HomePage is very heavy just like what I have at http://www.raheelhussain.com/ , it is possible that the Search Engine Spider that might want to index your HomePage and entire site, might skip you (I mean your website) if it gets Timed Out while loading your page.

The page size of your HomePage for such a case (recommended by many experience webmasters) should be less than 125k.

While analysing my website, I found of couple of more things :

A huge amount of ViewState - Hidden Data
Due to AJAX implementation, the View State gets increased, unless we explicitly disable it on all occurances except wherever required.

Script Source Files with AJAX may increase your page size
When you use AJAX in your site, it includes lots of Script Sources files in the page sources, to support the functionalities like as follows :

<script src="/ScriptResource.axd?d=e0Z5w1xlI94kfI-ca3Wnd_wh0&t=633309435532426250" type="text/javascript"></script>

You will find a big number of References to such files... the more you use different AJAX functionalities on to the site.
So the recommendation is that you may use very less AJAX functionality on the HomePage at least.

Too many External Http Objects references.
To further explain this, each reference to an external file is refered as an external HTTP Object, You may take the example of http://www.google.ae/ or
http://www.yahoo.com/ as these sites are with very less references to external object and are really fast loading.

To demonstrate this, I went to http://www.websiteoptimization.com/services/analyze/ which is a free tool to analyze your site.
I did that for http://www.yahoo.com/ , http://www.google.ae/ and finally for my website http://www.raheelhussain.com/ for comparision.

Though the site for http://www.asp.net/ is also heavy, but my website (being very simple) was more havier than it.

You when you do it, you'll see the external object references, listed in a separate table.

Above is for http://www.yahoo.com/ and http://www.google.ae/ is even better with less load time.

Image sizes
Offcourse the image sizes need to be lesser unless there's really a need to put a bigger image file on the homepage.

And the Important One - The GuestBook
Since the Guestbook consumes/implements most of the AJAX functionalitiy. The conclusion to this is, that unless you do not have a requirement, keep all the
functionality in the inside pages, rather than keeping it on the Homepage.

Working out further, I gathered following Tips and Tricks to make a website, or at least the home page efficient and fast loading.

Fewer external Objects, means try to group them maximum into one combined, rather than many.

Turn on HTTP keepalives for external objects. Otherwise you add an extra round-trip to do another TCP three-way handshake for every HTTP request. If you are worried about hitting global server connection limits, set the keepalive timeout to something short, like 5-10 seconds. Also look into serving your static content from a different webserver than your dynamic content. Having thousands of connections open to a stripped down static file webserver can happen in like 10 megs of RAM total, whereas your main webserver might easily eat 10 megs of RAM per connection.

If your users regularly load a dozen or more uncached or uncacheable objects per page, consider evenly spreading those objects over four hostnames. This usually means your users can have 4x as many outstanding connections to you. Without HTTP pipelining, this results in their average request latency dropping to about 1/4 of what it was before.
Minimize HTTP response size by enabling gzip compression for HTML and XML for browsers that support it. For example, the 17k document you are reading takes 90ms of the full downstream bandwidth of a user on 1.5Mbit DSL. Or it will take 37ms when compressed to 6.8k. That's 53ms off of the full page load time for a simple change. If your HTML is bigger and more redundant, you'll see an even greater improvement.

I've implemented most of the changes on my website but it is yet to go live again.
Possibly by the end of this month.

Regards - raheel Hussain

References :
http://www.websiteoptimization.com/services/analyze/wso.php
http://www.websiteoptimization.com/services/analyze/

SubSonic - Part 1 - An Introduction

Manjula Perera — Thu, 03 Jan 2008 06:27:00 GMT

Overview

This is another interesting article about the new trends of the software industry. I would like to share the information I gathered while researching on this new toolset with the user group members and the readers of this blog. I thought of writing about SubSonic because it's another way of accessing/ Querying the database (Actually, SubSonic is a third party toolset to auto generate the Data Access Layer (DAL) of our application and maintain it when the database changes). This is just another handy tool for us as LINQ. Therefore I'll write about SubSonic in parallel to the LINQ articles. We can compare LINQ and SubSonic later on. Since this is the first article about SubSonic in this forum I'll start with an introduction.

What is SubSonic?

SubSonic, initially named as ActionPack is developed as an open source project by Rob Conery before he joined Microsoft, but who is currently working for Microsoft in the ASP.Net team under Scott Guthrie. The other team members of this project are Eric Kemp, Scott Watermasysk, Jon Galloway, Phil Haack, and Gavin Joyce. This project has got attention from Microsoft even though it is still an open source project. SubSonic will be developed on top of ASP.Net and the new MVC framework that Microsoft has given more attention of. (This information is true at the time of writing this article and as per the SubSonic Project & Rob Conery's comments)
We can download the latest source code here
SubSonic is a toolset that helps a website build itself. It brings some of the fun and elegance of Ruby on Rails to ASP.NET
This implements Active Record design pattern.
Helps us quickly build data driven websites without writing data manipulation code
Has a DAL generator that enables us to rapidly create strongly typed collections and CRUD (Create, Read, Update and Delete) enabled objects, which represent the selected database tables
Has an object relational (OR) mapper which extends to stored procedures and views
Could also automatically generate the UI for the data manipulation tasks (scaffolding support). This is very handy when creating the admin panel of a data driven web applications. We don't need to worry about creating it from scratch
Has a dynamic query tool that let us use SQL Server, MySQL and Enterprise Library (Application Blocks) without having to know the underlying SQL syntax (Lets go into technical details in the next articles to follow)
We just need to give the reference to the SubSonic DLL and set SubSonic settings in the Web.config file to make use of the power of SubSonic (Lets go into technical details in the next articles to follow)
Saves lot of development time and that is the main objective of creating SubSonic. Will our bosses give more work for the time we save using SubSonic?

Summery

SubSonic is an open source tool set to auto generate data manipulation code and interfaces. This works on top of ASP.Net and the MVC framework. This gives an extension and a cool new addition to the strength of .Net compliance languages and most importantly this SAVES lot of development time.

Rule Of Thumb

I'm pretty sure SubSonic will not replace classic SQL, T/SQL or PL/SQL but it will extend the data manipulation capability of the programmer. IT saves lot of time. It's a pretty cool tool to be in our tool box. We as the programmers must decide when to use it and when not to.

References

LINQ - Part 2 - FAQs & Answers

Manjula Perera — Wed, 02 Jan 2008 05:42:00 GMT

Overview

I thought of listing down few Frequently Asked Questions about LINQ and their answers before proceeding to the technical details of it. This is mainly because I might have missed any introductory information regarding LINQ. Please refer to the below LINQ FAQ related web postings.

More Links to LINQ

Links to LINQ

Visual Studio 2003/2005 keyboard shortcuts

Manjula Perera — Mon, 31 Dec 2007 12:11:00 GMT

Tip

I just found these interesting articles and thought of sharing with the readers of this blog and the user group members. You could find most of the keyboard shortcuts of Visual Studio here. And you could download a poster of your preffered language here.

Enjoy!

References

Coding Horror - by Jeff Atwood

Rob Caron's Blog

LINQ - Part 1 - the new querying enhancement to C# and VB.Net

Manjula Perera — Sun, 30 Dec 2007 13:23:00 GMT

Overview

I thought of gathering some information about Microsoft's latest querying technology and summerising that information here so that readers of this Blog and the members of the .NetFoundry user group will benefit from it. There's lot to talk about LINQ. Therefore I'll split this article into several parts and publish separately. Since this is the first article about LINQ in the user group I'll start with an introductory and would try to give a glimps in to LINQ.

What is LINQ?

LINQ - Language INtegrated Query
Is an extension to .Net compliant languages like C#, VB.Net and others for general purpose querying
Object based, language integrated way to query over data no matter from where that data came from or generated
Is a universal querying mechanism where we can query objects, collections, text files, relational data and XML
Could retrieve data from any object that implements the IEnumerable<T> interface
Is an integral part of Visual Studio 2008 and could incorporate with Visual Studio 2005 as an additional CTP download
Used to overcome the impedance mismatch between programming languages and database
LINQ has been separated into three main areas. They are,

LINQ to Object
LINQ to ADO.Net (LINQ enabled ADO.Net)

LINQ to SQL - DLINQ
LINQ to DataSet
LINQ to Entities

LINQ to XML - XLINQ

Highly extensible

LINQ Architecture

The architecture of LINQ is depicted below and it is self explanatory.

Advantages of using LINQ

There's a common syntax for querying any data source mentioned above. This eliminates the one source - one query language concept. I.e. for example Relational Data -> SQL, XML Documents -> XPath and .Net objects -> .Net built in operators such as foreach.
Able to use LINQ with .Net 1.x and .Net 2.0 objects
Able to extend LINQ to support new classes and technologies
Integrated to the .Net framework thereby accessible from any .Net compliant language (native code) and make use of their stregths and compile time syntax checking. E.g. it inherits the new C# language features like,

Implicitly typed variables e.g. var keyword
Extension methods
Lambda expressions
Anonymous types
Expression Trees

Avoids dynamic creation of string queries within native code (e.g. C#) and thereby avoiding the disadvantage of not having compile time checking of queries. I.e. eliminating mixture of native code and none native code. This also saves time on creating a dynamic query.
Intelli sense is available in Visual Studio
Designer support
Gives more power to the front-end programmer to manipulate data
Shorter learning curve
Could access stored procedures and user defined functions in a relational database

Disadvantages

Mainly focus on or support SQL Server but not Oracle or other databases such as MySQL, DB2. Others have to provide their own provider model or extension.
Lack of "Left/ Right" keywords in a Join even though the objectives are met
Data manipulation logic/code is written in the application rather than the DB end in LINQ to SQL.

This would be a problem when we want to change the logic without changing or re-compiling the application code
Problem of viewing the execution plan and optimising the query

Database programmers would be jobless (Joke!)

Summery

LINQ is a common method of accessing objects that implements IEnumerable <T> interface, relational data, text files and XML. This gives an extension and a cool new addition to the strength of .Net compliance languages even though there are several disadvantages of it.

Rule Of Thumb

I'm pretty sure LINQ will not replace classic SQL, T/SQL or PL/SQL but it will extend the data manipulation capability of the programmer. Its a pretty cool tool to be in our tool box. We as the programmers must decide when to use it and when not to.

References

MSDN - 101 LINQ Samples

The LINQ project

ScottGu's Blog

The evolution of LINQ and its impact on the design of C#

Rediscovering IEnumerable<T> - by Tomas Restrepo

What is LINQ? by Saquib Ullah

Dedicated website for LINQ

Is LINQ the future of database development? - by Arthur Fuller

Biggest Online Collection of Free Books

Raheel Hussain — Fri, 28 Dec 2007 15:04:00 GMT

Hello all,

Just got to know from a very good friend of mine, ... and thought to share it on my blog too

Whether it is Network, Programming, Certification, Webvelopment ..............
Microsoft ....... Sun Microsystems... or Security etc.

All the latest books and you may find almost all the books

Just check it out,

http://www.xpressionsz.com/

Regards - raheel

Free Voucher for Microsoft Certification Exam

Raheel Hussain — Fri, 28 Dec 2007 14:49:00 GMT

This is a very good but limited offer from Microsoft, to get a second chance to appear for the same exam if you fail.

Its a second shot for you

- Register with any prometric test center of you region/area to appear in the exam
- Take the exam
- Suppose if you fail then show this Voucher to the Prometric center and re-schedule and register for the same exam

For more details follow the link :

http://www.microsoft.com/learning/mcp/offers/secondshot/default.mspx

Good Luck !

Beware with Math.Round() in C#

Manjula Perera — Wed, 26 Dec 2007 07:44:00 GMT

Problem

Recently I found an issue with the Math.Round() function in C# while working on an enhancement project written in Visual Studio 2003. I.e. this function is using the Banker's method. The users of this system didn't like the way figures are getting rounded and they wanted the method used in Excel (Because they are used to Excel ). I.e. Symmetric Arithmetic Rounding method. E.g

Say we want to round 1234.50000 into the nearest integer value. Then Math.Round() returns 1234 whereas MS Excel gives 1235.

I also found a similar issue in SQL Server 2000 some time back. It seems that Microsoft uses contradictory methods of rounding in their products (Visual Studio, SQL Server, Visual Basic, Excel etc.)

Most of us learnt this banker's method while schooling. But it seems that there are many other ways of rounding. Click here to view all methods of rounding and how you can implement custom rounding procedures.

Solution

Visual Studio 2003 - If we want to use Symmetric Arithmetic Rounding method we have to write our own function instead of using Math.Round(). See below for a working function found in CoderSource.Net.

public static double roundNum(double num, int place)
{

double n;
n = num * Math.Pow(10, place);
n = Math.Sign(n) * Math.Abs(Math.Floor(n + .5));
return n / Math.Pow(10, place);

}

Visual Studio 2005 - This problem is sorted in this version of Visual Studio. We can now select the rounding method in;

System.Math.Round

Rule Of Thumb

Always ask from the users which method of rounding they want during the system requirements gathering stage. This will avoid us being using the default method of rounding in our chosen development language. In this case C#.

References

Wikipedia

Microsoft Help and Support

CoderSource.Net