Here I want to write about some quick tips with XElement class, that I'd like, every LINQ to XML programmer, always remember.
Lots of time I saw a questions about how to do SQL like JOIN operations with sequenced objects, in application using LINQ. So I've decided to produce easy to understand samples of JOIN
operations with LINQ technology which works ok
as with LINQ to SQL so with LINQ to Objects.
The most frequent problem that I met with developers who are dealing with LINQ To SQL is database connection string flexibility problem.
An engineer, a manager, and a programmer are riding in a car. They come to a hill and their brakes fail. After careening down the hill and finally coming to a stop they get out to decide what to do. The manager says "We need to have a meeting to form a committee to see what we should do next!" The engineer says, "Screw that! Give me a pocket knife and some duck tape and I'll have us going in no time!" The programmer looks at them both and says, "Lets push it back to the top and see if it does it again.
In this post I want to demosntrate how to accomplish SQL CASE WHEN
like condition in LINQ.
If you ask two girls, how old they are, may be you would hear them to refuse to answer your question. Both girls are giving you NULL as age and this doesn't mean both have similar age. So there is nothing can be equal to null.
Just enjoy your life sometimes ;)
Data paging is a very popular requirement for software products, especially in web projects. With coming LINQ technology, it became very easy to bring n-th page data on the form.
Back and want to continue speaking about common problems. This time want to introduce image thumbnailing or resizing solution. It very usefull, especilly if you want to build image gallery, when you need to display thumbnail list and reveal
original image on click. This will work for both web and desktop applications, but there is some workaround with web is you want to get best results.
Most of web developers,less once in their lives, meet a problem calling Multilingual Website Implementation
. All "Getting Started with ASP.NET" books describing the solution of this problem, in one of the chapters.
But here I want to introduce, quick, easy to understand and ready to go solution for "multilingual" task.
In this second part I'll speak about retrieving data from SQL Server database using LINQ.
LINQ (Language-Integrated Query) is technology, introduced by Microsoft in 2008 with .Net Framework 3.5 and Visual Studio 2008.
As for me, LINQ is the most easies way for establishing communication, between application and database, for retrieving data from lower level.
Below I'll describe how everything works with LINQ and side by side share my knowledge, vision, experience and best achievements which came to me by this time.