A Taste of LINQ to SQL

Over the part few months, I'm using LINQ to SQL in my .Net projects.. It's one of the most attactive features I've in .NET Framework 3.5 .. Al tough the full release of LINQ to SQL is scheduled with upcoming Visual Studio Orcas; but still Visual Studio 2008 has most of its features..

Those who dont know anything about LINQ; well LINQ stands for Language Integrated Query and as the names shows LINQ is Code based language designed for data manipulation in different data structures like Lists, Array, KeyValue Pairs etc..


What is LINQ to SQL?
LINQ to SQL is an Object Relational Mapping implementation that ships in the .NET Framework "Orcas" release, and which allows you to model a relational database using .NET classes. You can then query the database using LINQ, as well as update/insert/delete data from it.

LINQ to SQL fully supports transactions, views, and stored procedures. It also provides an easy way to integrate data validation and business logic rules into your data model.

(Taken from ScottGu's Blog)


Reasons I Choose Linq to SQL
Reason number one.. LINQ is Cool :) Actually there are so many reasons for going with LINQ to SQL..

• LINQ is quite easy to understand
• Ddata manipulation can be done without breaking your nerves
• SQL Injection threat is very low.. Almost negligible
• We can use one single language through out the project both for Database Quering and internal data structures
• and bla bla bla...

Let's Get Started
Im breaking it in following parts..

• Creating the project
• The LINQ to SQL Connector and Data Context
• Whats the difference in LINQ And SQL Queries?
• Simple Queries
• Some Data Manipulation

Image Viewer BETA

Its really old post and available on PS Code since January 2010 therefore I'm not going to cover this in detail.. In short Its an Image Viewer with some additional stuff.. I have tried to fix as much bugs as i can but I know there are still bugs left.. Thanks to all those unknown people who post there experience and ideas which help me out to complete this project..

Specially i thank to creater of CButton which i used in this project. Ther'ree really amazing I hope my work will be useful for other people as well Work with it as much as you want as long as you include these lines with you code. But dont forget to send me a copy of your work on it. This project can help you in following...

1. Windos Form Controls Array with event handling
2. Browsing files and folder
3. Form Designing
4. Moving Borderless Form
5. Making Transparent Splash Screen Effect.
6. Image Processing similar to Windows Image Viewer
7. Setting Image as wallpaper etc..

Thanks For your apprecation.. Dont forget to Comment.. :)

Here is the source of this application : Image Viewer

Jazak Allah..