SUN Jiangong's technical blog

/*by Jiangong SUN*/ Here I want to introduce "Let" operator in entity framework. Let operator can define a variable in your linq query and then use it in your query. For example :  activit

/*by Jiangong SUN*/ Here I create a stored procedure for searching dealers in my database, it can receive several parameters. USE DATABASENAME; GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER O

/*By Jiangong SUN*/ Today is thanks giving day! LOL :) Firstly we have a list :  List FeaturesList = new List(); foreach (var feature in Model.Features) { for (int c = 0; c <

/*By Jiangong SUN*/ How to read XML file easily? 1. You can get your stream with a given url. private string GetStreamString(string url) { try {

/*By Jiangong SUN*/ This error probably occurs when you modify your tables and their relationships with other tables in your data model.  I've seen this error several times today when i update my

Knowledge Conclusion - PART III: Entity framework & SQL Server