For some reason, every time I closed my (specific) solution from Visual Studio .NET (2003) the IDE throw an "The operation could not be completed" error. After I've tried to open another(different) solution in the same IDE instance, the solution was not bounded to the VSS !
I swear, this is a regular solution structure... nothing fancy;
After digging a little, and talking about it with Amir (aka "The Markowitz"), we've come to the conclusion that the solution (*.sln) file have problems with the VSS. It became obvious when I tried to add a file to the Solution Items and I simply couldn't check-in the new file.

I've start googling about "troubleshoot VS.NET log" but no luck, I can't seem to find a log file which will give me some more data about the "The operation could not be completed" error. I hate the "restart-your-computer" solutions style, but after I've spent 2 hours exploring the *.sln files, *.csproj files and tried to reproduce the problem on a different solution(tester), I was getting tired and frustrated.

As last resort, I've unbounded the all solution, deleted (permanently) the $/MyProject directory from the VSS and reattached the all solution to the VSS again using the recommended guideline.

Now everything is good, weird ah ?

I'm working on my Code Generator so it will be able to generate stored procedures for me. Until now I generated the SQL queries in my C# code, but now, due to a development request(\demand) from my client I must work with stored procedures.

The first thing I thought about is how to make my search pages easy to upgrade and maintain if I'm going to use SP(stored procedure). Now, when I need to add another Field to my dynamic where clause, it's quite simple - I'm building the query in my data ccess object according to the parameters and everything is OK. I feared that by using SP for my search pages, I'll need to call something like EXEC which looks like a joke - If you must call EXEC in the SP, you better put the SQL in your C# code and get it over with.

After doing some searches, I found this article which present a way to build and execute dynamic where clauses with "COALESCE" function. After I've searched a little more, I found a similar way to do the same thing with better performance:

" I check the value against NULL and achieve good performance and flexibility. No problem with LIKE values either:

WHERE
(@title IS NULL OR title LIKE @title)
AND
(@min_release_date IS NULL OR release_date >= @min_release_date)
AND
(@document_id IS NULL or document_id = @document_id)

Great performance and flexibility! All indexes are used as expected. " (Zelk)

Looks great !
If the sent parameter is null, don't "cut" the results by the parameter, else - use it...

OK, I must dig into my generator and start implementing this... 

Sometimes my VS.NET just can't "catch" my breakpoints in my .js files for some reason.
Yes, I made sure that the "Script" box is checked on the attached process, still, no luck.

Fortunately debugger; command is in the house !

It's simple to use and it can be great for production debugging as well.

example (in myexample.js file):
function MyMethod()
{
   debugger; // ==> this will make the debugger to take over (you can use VS.NET or any other suitable program).   

   // your code to debug here.
}

Damn, such a long title... I must take a minute to relax; Done -

I had to change the directory name of my Web project in order to ease my build process.
Well, I must admit, this isn't an easy task when you don't remember the steps or you're too
tired to messing around with it (rule of thumb: gather the required powers, it won't get easier to adjust it later you know).

So, from my experience here are the steps for changing the VSS bounded ASP.NET project
directory name without killing your VSS\Solution:

1. Close the solution if it's open (i.e - close the Visual Studio .NET).
2. Create the new directory name you want to address the ASP.NET project into.
3. Go to the IIS (Ctrl + Q -> iis, oh wait, assuming you've followed my advice and installed SlickRun) and change the virtual directory path to point to the new directory.
4. Open the *.sln file with notepad (right-click->open with...) and find "SccLocalPath[number]" which points to your current(unwanted) directory name; overwrite the directory name with the new directory name.
5. Delete the *.suo file - NOTICE: this is a hidden file so you must check the option to view all the hidden files (OS configuration). This file keeps the user configuration about the solution (like what is my StartUp project\file etc.)
6. Open the *.sln via VS.NET and you'll get a window which will ask you to choose the web project path (http://localhost/VirtualDirectoryName_1) - remove the "_1" suffix and click OK.
7. Delete the old web project directory. TIP: if you're trying to delete the old web project directory and you'll get an error that there are files in use - try to delete VSWebCach directory (in your c:\Documents and Settings\[username]) and then try to delete the directory again.
8. Drink something and relax, you deserve it !

I'm struggling with myself about what's the best way now to create an automated build mechanism for my dotNET project. I read a lot during the last weekend about using Nant and Nant Contrib and I've managed to pull something off quite easily. * I'll upload the build file and my remarks about the process as soon as I'll finish (Can't wait ah ? ).

I saw that Microsoft shipped their automated tool - MSBuild - with VS.NET 2005 (beta 2); But in order to make use of MSBuild in my v1.1 .NET framework, I'll need to do some DIRTY hacks which I don't seem to like in this case. You ask yourself why ?

1. This is a beta version, meaning the bugs will be all over me !

2. I personally think that using the beta version of any program in my Production environment is a big risk, too big in my opinion.

3. Let's say that I found a bug and I need to get it fixed; MS will cry that this version isn't supported in v1.1 framework (dah! that's why I did my dirty hack) and in any case it's only a beta and I need to wait for the final release - and they'll be right ! (damn, I hate when it happens).

4. NAnt is an old(sorry... but I mean it as a compliment) open source freeware - there are less bugs and I can always dig in and make the required changes !

Therefore, I'm thinking of staying with NAnt just until the final release of MSBuild will be available.

What do you think ?

1. Create the directory [solution-path]\[web-project\webservice name]
2. Go to my IIS and add the required virtual directory which will redirect to step 1 path.

1. You can create the virtual directory under a WebSite by using "WebSiteName" element under the "Directory" element.
2. If the "DirectoryPath" doesn't exist - the utility will create it before setting the Virtual Directory path.

After logging in, be sure to visit all the options under Configuration in the Admin Menu Bar above. There are 26 themes to choose from, and you can also create your own.