LINQ to SQL Classes

31 באוקטובר 2007

One can only wish everybody to speak LINQ!   The following solution demonstrate how to query database tables with object relational data classes. For this example you need to download and install the AdventureWorks Database provided by Microsoft.   First, create a new console project:    Open the "Server Explorer", click on the "Connect to Database" button:   Select the Microsoft SQL Server:   The next step is to connect to your AdventureWorks Database Server, from the "Add Connection" window. Select the appropriate Server and Database (AdventureWorks) and click OK. After that, you should see the AdventureWorks.dbo in...
2 תגובות

Download Microsoft AdventureWorks Database

Usually when we start writing a new program, or just playing with LINQ, we need a database with some information on it like tables, stored procedures and some data to play with. Microsoft offers a complete database called AdventureWorks just for that cause. The database contains more then 50 tables, 9 stored procedures and a few views and functions.   For SQL Server 2005, you can download it from here: http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004   I downloaded the AdventureWorksDB.msi and the run the following query in the SQL 2005: 1: exec sp_attach_db @dbname=N'AdventureWorks', 2: @filename1=N'C:\Program Files\Microsoft SQL...
תגובה אחת

Vista Hebrew Pack with Media Center

27 באוקטובר 2007

I downloaded the Hebrew pack for my media center PC. The results are great! All the text is from right to left, and more readable now. if you like to install the Hebrew pack, you can do in from the Windows Update.   Here is some pictures from my Media Center in the living room.   The main Window:     The TV Guide:   The recorded TV:   Live media from the Internet:
תגיות: ,
3 תגובות

Tutorial – Create a new theme to your blog

18 באוקטובר 2007

So, you want your blog to look sexy, sure you do, here is how... Before you start reading this lines, you need to know that to customize and styling your blog takes time, and allots of patience. Also, I've attached my style XML (Exported) for your convenient's, so if you like to see my setting, import the XML from your blog Control Panel.   Create an image in 800x235 for your header, I download my image from the web after long searching: Of course you can create a smaller image if you like.   Then Go to...
תגיות: , ,
תגובה אחת

OneNote2007 – Capture This!

15 באוקטובר 2007

Yet, another OneNote2007 post...   OneNote2007 is a great progy, Odd!... I've swear I said that before, never mind, its worth it! So lets say you writing a note, and lets say you wish to add an image to you note, OneNote2007 gives you the ability to capture an image on the fly...   Press the "Window button" + S - and oops, the screen goes blank!   Now, select the area you want to capture and, witness the magic. The new image will appear in a new note (this is by default, but you can change that):      Enjoy!
תגיות: ,
אין תגובות

Radiohead to release "In Rainbow" for free!

Radiohead band choose to release their new album "In Rainbows" for free or for a price that you decides. If you wish to download it, just go to their new site of the album, add it to your shopping cart (after feeling some details) and download it. Off-course you can choose to pay some amount of money (in pounds) - as you wish. So far, more than a million people already downloaded the album and declare they paid for it!    Enjoy!
תגיות: ,
אין תגובות

Visual Studio 2005 Recent Projects Manager

14 באוקטובר 2007

I didn't find a way to delete projects from my Recent Projects List in visual studio 2005, so I made this Add-In to manage them.   Place the 2 files in the RecentProjectsManager.zip (Attached) into the Add-In folder: MyDocuments\Visual Studio 2005\Addins   Load the visual studio, click "Tools" and then "Recent Projects Manager"   Please let me know about any problems you encountered: gilad.lavian@gmail.com
תגיות: , , ,
אין תגובות