Nisi’s work blog

MonoDevelop is a free and feature advanced IDE for C# and other .NET languages.

The great feature of all is that it work on Linux, Windows & Mac OSX. You can change your operating system but you dont need to change your IDE.

• code completion support for C#
• code templates & code folding
• integrated debugger
• web server (for instantly testing ASP.NET applications)
• GTK# visual designer
• source control
• makefile integration
• unit testing
• packaging & deployment
• localization

MonoDevelop Home Page: http://monodevelop.com/

It is possible? In the web development open source is similar with PHP & MySQL and a tone of free CMS based on them. Now it is possible with .NET too. How?

LiveUI is the answer and is built for .NET 3.5 sp1

• Based on pure ASP .NET
• Pluggable to any asp.net application
• jQuery and ExtJS support
• Composite approach
• 100% testable application code

To download LiveUI and documentation: http://liveui.net/

Availble for download as kits and not as virtual machines on Microsoft’s msdn site

• Visual Studio 2010
• .NET Framework 4 Beta 1

Download link http://msdn.microsoft.com/en-gb/netframework/dd819232.aspx

char[(n)]
Fixed-length non-Unicode character data with length of n characters. n must be a value from 1 through 8,000. Storage size is n bytes.

nchar[(n)]
Fixed-length Unicode character data with length of n characters. n must be a value from 1 through 4,000. Storage size is two times n bytes.

varchar[(n)]
Variable-length non-Unicode character data with length of n characters. n must be a value from 1 through 8,000. Storage size is the actual length of the data entered, not n bytes. The data entered can be 0 characters in length.

nvarchar[(n)]
Variable-length Unicode character data with length of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length.

bigint
Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). Storage size is 8 bytes.
The bigint data type is available in SQL Server 2000 or later.

int
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647). Storage size is 4 bytes.

smallint
Integer data from -2^15 (-32,768) through 2^15 – 1 (32,767). Storage size is 2 bytes.

tinyint
Integer data from 0 through 255. Storage size is 1 byte.

Date and time data types for representing date and time of day.

datetime
Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.

smalldatetime
Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute

Monetary data types for representing monetary or currency values.

money
Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 – 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. Storage size is 8 bytes.

smallmoney
Monetary data values from – 214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. Storage size is 4 bytes.

Numeric data types with fixed precision and scale.

decimal[(p[,s])]
Fixed precision and scale numbers. When maximum precision is used, valid values are from – 10^38 +1 through 10^38 – 1.

p (precision) specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38.

s (scale) specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. The default scale is 0; therefore, 0 <= s <= p. Maximum storage sizes vary, based on the precision.

numeric[(p[,s])]
A synonym for decimal.
float[(n)]
Floating point number data from – 1.79E + 308 through 1.79E + 308. n is the number of bits used to store the mantissa of the float number in scientific notation and thus dictates the precision and storage size. n must be a value from 1 through 53.

real
Floating point number data from -3.40E + 38 through 3.40E + 38. Storage size is 4 bytes. In SQL Server, the synonym for real is float(24).
text

Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31 – 1 (2,147,483,647) characters. Storage size is the actual length in bytes of the data entered.

ntext
Variable-length Unicode data with a maximum length of 2^30 – 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered.
binary[(n)]

Fixed-length binary data of n bytes. n must be a value from 1 through 8,000. Storage size is n+4 bytes. When n is not specified in a data definition, the default length is 1.

varbinary[(n)]
Variable-length binary data of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length of the data entered + 4 bytes, not n bytes. The data entered can be 0 bytes in length. When n is not specified in a data definition, the default length is 1.

image
Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.
bit
Integer data type that can be 1, 0, or NULL.

uniqueidentifier
A globally unique identifier (GUID). A column of uniqueidentifier data type can be initialized using the NEWID function or converting from a string constant in the following form: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, in which each x is a hexadecimal digit in the range 0-9 or A-F.

timestamp
A database-wide unique number that gets updated every time a row gets updated. The value of a timestamp column is unique within a database. The storage size is 8 bytes.

How to create a new xml with LINQ

[sourcecode language='csharp ']

var objCars= new[]
{
new {CarID = 2, CarName = “Ford”, Fuel = “Diesel”},
new {CarID = 3, CarName = “Audi”, Fuel = “Diesel”},
new {CarID = 4, CarName = “Mercedes”, Fuel = “Diesel”},
new {CarID = 1, CarName = “BMW”, Fuel = “Diesel”}
};

XElement _cars = new XElement(“cars”,
from c in objCars
select new XElement(“car”,
new XElement(“name”, c.CarName),
new XAttribute(“ID”, c.CarID),
new XElement(“Fuel”, c.Fuel)
)
);
Console.WriteLine(_cars);

[/sourcecode]
so this will print something like:

Ford
Diesel

Audi
Diesel

Mercedes
Diesel

BMW
Diesel

string s = String.Format("{{ hello to all }}");
Console.WriteLine(s);    //prints '{ hello to all }' 

int i = 42;
string s = String.Format("{0}", i);   //prints '42' 

int i = 42;
string s = String.Format("{{{0}}}", i);   //prints '{42}' 

int i = 42;
string s = String.Format("{0:N}", i);   //prints '42.00' 

int i = 42;
string s = String.Format("{{{0:N}}}", i);   //prints '{N}' 

int i = 42;
string s = String.Format("{0:N!}", i);   //prints 'N!' 

int i = 42;
string s = String.Format("{{{0:N}}}", i);   //prints '{N}' 

string s =
String.Format("{0}{1}{2}", "{", i, "}");   //prints '{42.00}' 

int i = 42;
string s = String.Format("{{{0}}}", i.ToString("N")) ;   //prints '{42.00}' 

int i = 42;
string s = String.Format("{0:{{0.00}}}", i);   //prints '{42.00}' 

int i = 42;
string s = String.Format("{0,-7:N}", i);   //prints '42.00  ', ",-7" left-justifies the string 

int i = 42;
string s1 = String.Format("{{{0,-7:N}}}", i);   //prints '{42.00  }'
string s2 = String.Format("{{{0,-7}}}", i.ToString("N")) ;   //prints '{42.00  }'
string s3 = String.Format("{0,-9:{{0.00}}}", i);   //prints '{42.00}  ' 

int i = 42000;
string s = String.Format("{0,-15:{{#,##0.00}}}", i);   //prints '{42,000.00}     '