While in the designer for the DBML, you can right-click on any white-space, and click on Properties (not the same as right-clicking on the DBML file and clicking Properties). From there, expand the “Connection” option. Set “Application Settings” to False and clear out the “Connection String” setting. These settings are what the designer uses to … Read more
I disagree with John’s answer. The DataContext (or Linq to Entities ObjectContext) is more of a “unit of work” than a connection. It manages change tracking, etc. See this blog post for a description: Lifetime of a LINQ to SQL DataContext The four main points of this blog post are that DataContext: Is ideally suited … Read more
C# has Convert.ToInt32() which should do what you’re looking for.
Rick Strahl has a nice article about your options: http://www.west-wind.com/weblog/posts/246222.aspx. See also: LINQ to SQL – where does your DataContext live?. You may want a slightly different strategy for each type of deployment – web, desktop, windows service… Summarized, your options are: Global DataContext – dangerous in multi-threaded environments (including web apps). Remember that instance … Read more
The example data and output you’ve provided does not demonstrate a left join. If it was a left join your output would look like this (notice how we have 3 results for user 1, i.e. once for each Growth record that user 1 has): User | age| Data |Growth ———————— 1 |2 |43.5 |46.5 1 … Read more
You have to use the Contains method on your id list: var query = from t in db.Table where idList.Contains(t.Id) select t;
To ignore case and accents (diacritics) you can first define an extension method like this: public static string RemoveDiacritics(this String s) { String normalizedString = s.Normalize(NormalizationForm.FormD); StringBuilder stringBuilder = new StringBuilder(); for (int i = 0; i < normalizedString.Length; i++) { Char c = normalizedString[i]; if (CharUnicodeInfo.GetUnicodeCategory(c) != UnicodeCategory.NonSpacingMark) stringBuilder.Append(c); } return stringBuilder.ToString(); } (Modified … Read more
LINQ only directly supports equijoins. If you want to do any other kind of join, you basically need a cross-join and where: from a in tablea from b in tableb where a.col1 == b.col1 || a.col2 == b.col2 select … It’s probably worth checking what the generated SQL looks like and what the query plan … Read more
Simple answer is “don’t use text”. It was deprecated for varchar(max) years ago when SQL Server 2005 was released. The code you have is issuing SELECT DISTINCT. You need to fix the model/tables so it isn’t text datatype
Have you looked at SqlMetal? It’s officially supported, although not promoted too much. You can use it to build dbmls from the commandline – we’ve used it as part of a db’s continous integration updates (make sure you have really good code separation if you do this though – partial classes are a saviour – … Read more