My Blogs Collection

http://www.davidhayden.com/blog/dave/archive/2006/12/21/QueryExpressionsAnonymousTypesLambaExpressions.aspxhttp://porwin-ebook.blogspot.com/search/label/Dot%20...

Wildcard in Sql Server Select

the LIKE operator allows us to perform basic pattern-matching using wildcard characters. For Microsoft SQL Server, the wildcard characters are defined as follows: Wildcard Description _ (underscore) matches any single character % matches a string of one or more characters [ ] matches any single character within the specified range (e.g. [a-f]) or set (e.g. [abcdef]). [^] matches any single...

LINQ To SQL Examples

I have recently been using LINQ to accomplish much of my data abstraction and have found it very useful for building a robust ASP.Net application. Ultimately what LINQ to SQL does is it translates your C# code into a SQL query and returns an object or an object list instead of a dataset. This can be much easier to deal with than a dataset. I have run into a couple things that I didn’t expect so I...