DevAffair

Test Driven Development in C#. This is a Short Introduction for Test Driven Development in Visual Studio 2010. This tutorial will contain short and basic explanation of Test Driven Development followed by a quick walk through in Visual Studio 2010 written in C Sharp. For those of you who don't know, Test Driven Development is a different way of coding.  Some say a different way of life.  Instead of first developing your software and then test it, What Test Driven Development Methodology offers is to first test, then code. Basically it allows us to cover a variety of User Stories and Test Cases, build the tests for them and only after all is covered - start coding while testing our code every step of the way.   Some principles of Test Driven Development: Tests serve as examples of how to use a class or method. Naming. be explicit as possible so that everyone will be able to understand, rewrite and maintain your tests. There's a simple "3 A's" pattern ...

Advanced Join Statements in MS SQL Management Studio. There are several different Join types in here I will discuss them: Cross Join Statement Full Join Statement Joining tables is one of the most useful operations we have. Large data should be divided to several tables (see Normalization Rules) for maximum flexibility and minimum resources usage. Cross Join Statement: In the Cross Join statement, based on the two tables within the Join, a Cartesian product is created if a 'Where' statement filter the rows.  The size of the Cartesian product is based on multyplying the number of rows from the left table by the number of rows from the right one. Be careful when using the Cross Join.  it might cause more damage than good. Example:     SELECT  TOP 100 P.ProductID,         P.Name,         P.ListPrice,         P.Size,    ...

Join Statements in MS SQL Management Studio. There are several different Join types in here I will discuss them: Inner Join Statement Left Outer Join Statement Right Outer Join Statement Self Join Statement Joining tables is one of the most useful operations we have. Large data should be divided to several tables (see Normalization Rules) for maximum flexibility and minimum resources usage. Inner Join Statement: Inner Join is meant for combining rows between two tables, based on at least one column with the same data. Although columns with the same data are the most common way to use the Inner Join, there is also a possibility to conduct it with "greater then", "not equal" etc. Example:     SELECT TOP 10 P.ProductID,         P.Name,         P.ListPrice,         S.UnitPrice,         S. OrderQty     FROM Sales.SalesOrderDetail S  ...

Configuring Asp.Net To Open New Browser Window When Start Debugging. Not too long ago I encountered a small problem that occurred to one of the developers in my team when he got a new computer. Previous to the new PC, whenever he clicked on "Start Debugging" (also known as F5) the solution compiled and opened a new browser window with the default page. After the new PC arrived the configurations in his Visual Studio 2010 were different. Meaning - Whenever he clicked F5, the project was compiling, but no browser windows appeared. With a short phone call I explained the steps he needs to do, but in order for it to be clear for all of us, I decided to upload it as a brief post. Right click on the project's name. Click on "Properties". A configuration manager window will open. Click on the third tab called "Web". On that tab you will have several sections, the first the is what we're interested in. on "Start Action" section (...

How to create configuration or Environment variables in Visual Studio 2010. Environment variables are a great thing for when you publish your website to multiple places. It doesn't matter if you publish it to testing / staging / production environment or if you're publishing your site to several servers which require different methods to be called / different values assigned to parameters. Lets create a web application project (further explanations will be granted later) Open Visual Studio 2010 Create New Project -> ASP.NET Web Application As you can see, you automatically have two configuration options: Debug Release Right click on the project in the Solution Explorer . Click on Properties . Click on Build tab. Under that tab you have many configuration options (which will be discussed in another post). The field we're interested in is " Conditional compilation symbols ". While on Debug mode, we will write a variable name in t...

Select Statement Update Statement Insert Statement Delete Statement Select Into Statement Many times I forget the exact syntax I should use whether I'm writing in MSSQL, My-SQL or Oracle.  This post is the first out of three posts designed to gather basic database statements and show a simple and clean example to them. Select Statement: Syntax 1:  SELECT column_1, column_3                      FROM Table Example: SELECT ID, Name                 FROM tbl_customers Syntax 2: SELECT * FROM Table (meaning - select all columns). Example: SELECT * FROM tbl_customers Update Statement: Syntax 1: UPDATE Table                     column_1 = 'value' Example: UPDATE tbl_customers         ...

How To Write Good Code Funny Stuff... source . Hope you're having a good time, Elad Shalom, CTO at ITweetLive.com