Sql to linq

The 700ms+ gap is LINQ-2-SQL generating SQL from an expression and starting to materialize objects. It takes it almost a second after that to pull all the objects out. This happens every damn hit. Enough is enough. Time to port it to Dapper. There is a snag though, the page is using some pretty fancy expression stuff.LINQ to SQL and NOLOCK Hints. In our SQL queries here at work, we use the NOLOCK hint a lot. Not locking rows during reads is very important to us, and our transactions are seldom rolled back so the queries generally return data that's accurate enough for the tasks at hand. Now that we're starting to investigate LINQ to SQL, then, we're ...To accomplish this task successfully, first open your project in the solution explorer, right click->add->new item, in the 'data' categories, there is a type named 'LINQ To SQL Classes'. Select that. We will get a .dbml file created along with designer interface.With LINQPad, you can interactively query databases in a modern query language: LINQ. LINQPad includes an optimized engine to build typed data contexts on the fly, and includes drivers for SQL Server, SQL Azure, Oracle, SQLite, PostgreSQL and MySQL. LINQPad can also connect to Entity Framework Core contexts that you create in Visual Studio.NCache supports SQL and LINQ querying capabilities that let you query your distributed cache the exact way you query your database. For this reason, NCache provides various projections, operations and aggregate functions in SQL and LINQ support to reduce network traffic and enhance performance. NCache Details SQL Search in CacheFirst off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. Interacting with data in SQL Server Management Studio is very hard but it's not hard in LINQPad!Is it hard to write LINQ queries? wanna practice LINQ? so use...Sep 16, 2020 · An SQL-> LINQ converter. Or LINQPad: linqpad. BR, Mia. If the answer is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our ... Aug 27, 2009 · I tried linqpad but its not for converting SQL to linq but its actual use is to replace sql with linq to query your database however I think linqer is the right choice if you like to convert SQL query to LINQ. 3x3 f2l pdf Here Mudassar Ahmed Khan has explained with an example, how to perform Select, Insert, Edit, Update and Delete operations using LINQ to SQL Framework in ASP.Net using C# and VB.Net. This process is also known as CRUD i.e. Create, Read, Update and Delete in GridView using LINQ to SQL Framework in ASP.Net. TAGs: ASP.Net, GridView, LINQvar myContext = new DataContext (); var product = context.Products.Find (productId); // (assuming productId is your primary key) You can grab the code below and do any custom modifications you wish to set product.Context, but this is an example of modifying the DataContext. Data Querying. A LINQ to SQL query gets sent to the database only when the program needs to read data. For example, the following foreach loop iterates rows returned from a table:. var query = from c in Customers where c.Country == "USA" select c.CompanyName; foreach( var company in query ) {Console.WriteLine( company );} The code generated by the foreach statement is equivalent to the ...LINQ to SQL is an object-relational mapping (ORM) implementation that allows the direct 1-1 mapping of a Microsoft SQL Server database to .NET classes, and query of the resulting objects using LINQ. More specifically, LINQ to SQL has been developed to target the rapid development scenario against Microsoft SQL Server.First off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. A free PDF library that can be used to create, read, edit, convert and print PDF files within any .NET ( C#, VB.NET, ASP.NET, .NET Core) application. A free barcode library which is designed to generate and read most common 1D & 2D barcodes from any .NET applications.Sep 15, 2021 · LINQ to SQL itself translates all the necessary operations into the necessary SQL operations that you are familiar with. For more information, see LINQ to SQL. In the following example, the company names of customers from London are retrieved and displayed in the console window. // Northwnd inherits from System.Data.Linq.DataContext. Learn about creating a database from linqpad in the chapter "Querying Databases with LINQ-to-SQL" of Syncfusion LINQPad free ebook.Within Filter Query field of "Get rows" action, type the following formula: year (date1) ge 2018 and month (date1) ge 02 and day (date1) ge 12. The flow works successfully as below: When working with date value, we should get year, month and day separately.Query expression is nothing but a LINQ query, expressed in a form similar to that of SQL with query operators like Select, Where and OrderBy. Query expressions usually start with the keyword "From". To access standard LINQ query operators, the namespace System.Query should be imported by default.C# join Examples (LINQ) - Dot Net Perls. C# join Examples (LINQ) Use the join keyword in query expressions. Include the System.Linq namespace. Join. This is a keyword in LINQ. As with other query languages (such as SQL) joining matches every element in two collections based on some condition. Queries. We use this keyword in a query expression ...C# LINQ: Saving JSON Data to SQL Server Database using JSON.NET and SqlBulkCopy By Brij Mohan In this post, we will add JSON data to Sql Server tables using ASP.NET Web API, JSON.NET and SqlBulkCopy. indian male instagram influencers Hope this small LinQ to SQL like operator tutorial helps you understand the use of 'like' operator along with linq queries more easily and efficiently. I will continuously try to provide more advanced tutorial on LinQ to SQL as much as possible. If you have any question regarding this tutorial, feel free to ask them by commenting here.A linq-to-sql eBooks created from contributions of Stack Overflow users.Nov 28, 2012 · You haven't specified where you're wanting to use that LINQ fragment, so I want to point out (just in case it's what you're attempting to do) that in a query's PreProcessQuery method, you can't return something like po.PurchaseOrderID (this is callled "projecting"), you can only return po itself, if that's the entity that the query is based on. LINQ to SQL translates the queries you write into equivalent SQL queries and sends them to the server for processing. More specifically, your application uses the LINQ to SQL API to request query execution. The LINQ to SQL provider then transforms the query into SQL text and delegates execution to the ADO provider.LINQ to SQL offers an infrastructure (run-time) for the management of relational data as objects. It is a component of version 3.5 of the .NET Framework and ably does the translation of language-integrated queries of the object model into SQL. May 23, 2022 · SQLSTATE [HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE') select distinct. mssql find deadlocks. n highest salary in sql. The LINQ to Entities allows us to write queries (known as LINQ Queries) in C# and VB.NET. These LINQ queries are then transferred into the Expression Tree. The Database Provider ( Entity Client in EF6) will then use the Entity Model to translate LINQ Queries into the SQL query. The SQL query is then sent to the database using the Command object ... jumba bet free dollar100 LINQ and Entity Framework are both commonly used in the .Net ecosystem, but even well-written applications can have LINQ queries that are difficult to understand. Because LINQ is so flexible, it can be written in ways that fail to communicate the developer's intent. Well-written LINQ should be so clear as to be self-documenting.Interacting with data in SQL Server Management Studio is very hard but it's not hard in LINQPad!Is it hard to write LINQ queries? wanna practice LINQ? so use...By default it is Ascending, ordering from low to high. Imports System.Linq Module Module1 Sub Main () Dim values () As Integer = {3, 10, -1, 30, -3} ' Order the elements from low to high (ascending). Dim result = From v In values Order By v For Each value As Integer In result Console.WriteLine (value) Next End Sub End Module -3 -1 3 10 30LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources. Mar 06, 2019 · Now let’s see how to convert our SQL query to LINQ manually using code. We can insert, update and delete data from SQL to LINQ. For that, we can use the LINQ class available in the System namespace for the conversion. First, we need to create a database entity using LINQ to SQL class. To move on with this, create a new project and add a new ... Depending on your model you could perhaps use navigation properties rarher than joins. IMHO it's best to forget about the SQL statement. When using Linq it's likely best to adopt a C# rather than a SQL point of view (ie you are working with objects and collections, not with relational data). Nov 28, 2012 · You haven't specified where you're wanting to use that LINQ fragment, so I want to point out (just in case it's what you're attempting to do) that in a query's PreProcessQuery method, you can't return something like po.PurchaseOrderID (this is callled "projecting"), you can only return po itself, if that's the entity that the query is based on. LINQ to SQL performs a check whether this call was executed in the scope of the Transaction started by user (local or distributed), when SubmitChanges is called. It is executed in the context of the same transaction, if the DataContext.Transaction property is set to a DbTransaction instance. Please note, that you should either commit or ...While Linq to SQL may be dead, Linq to SQL has a lot of traction in the developer community. According to Data Direct Technologies 's recent .NET Data Access Trends Survey (November 24th, 2008), 8.5% of production .NET applications use Linq to SQL as their primary data access method.Linq to SQL is similar in the fact that you can easily ignore the underneath implementation (Linq) when unit testing, however I'm going to focus more on how to decide the system and how it all should hang together. Like in any Linq to SQL implementation you will need a data context. kk shader pack To accomplish this task successfully, first open your project in the solution explorer, right click->add->new item, in the 'data' categories, there is a type named 'LINQ To SQL Classes'. Select that. We will get a .dbml file created along with designer interface.The LINQ to SQL is a component of .NET Framework version 3.5, and it provides a run-time infrastructure to manage relational data as objects. The LINQ to SQL will allow us to access and get the data from the SQL database with LINQ queries. It allows us to perform select, insert, update and delete operations on tables like SQL using LINQ queries. At the same time LINQ to SQL still forms part of our strategy, because we believe it to be simpler to approach for many projects.So we also have and will be using LINQ to SQL. If anything LINQ to SQL replaces WORM for us which we used for a number of projects where we had good table to entity affinity.Aug 27, 2007 · LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data. Below are the first seven parts in this series: Sep 15, 2021 · LINQ to SQL itself translates all the necessary operations into the necessary SQL operations that you are familiar with. For more information, see LINQ to SQL. In the following example, the company names of customers from London are retrieved and displayed in the console window. // Northwnd inherits from System.Data.Linq.DataContext. Execute LINQ Query with string Dynamic Group By Dynamic Select Dynamic Where Clause Read More using (var context = new EntityContext ()) { var query = context.Customers .Where ("Orders.Count >= @0", 5) .OrderBy ("Orders.Count") .ToList (); } Parse Lambda MethodLINQ-to-SQL is not SQL LINQ is an entirely different query language that allows to embed declarative programming aspects into .NET languages, such as C#, or ASP. The nice part of LINQ is the fact that a C# compiler can compile something that looks like SQL in the middle of C# statements.dim sqlconn1 as new sqlconnection ( "databasesource" ) dim sqladaptor = new sqldataadapter sqlconn1.open () sqladaptor.selectcommand = new sqlcommand ( "select profile.individual_id, first_name, middle_name, last_name, sex, race, place_of_birth, county_of_birth, state_of_birth, date_of_birth, death.death_id, place_of_death, state_of_death, …Sep 15, 2021 · You define LINQ to SQL queries by using the same syntax as you would in LINQ. The only difference is that the objects referenced in your queries are mapped to elements in a database. For more information, see Introduction to LINQ Queries (C#). LINQ to SQL translates the queries you write into equivalent SQL queries and sends them to the server ... After looking at the code created by LINQ to SQL I noticed the following: this ._SalesOrderDetails = new EntitySet<SalesOrderDetail> ( new Action<SalesOrderDetail> ( this .attach_SalesOrderDetails), new Action<SalesOrderDetail> ( this .detach_SalesOrderDetails)); That's exactly what we need to detach each entity: reinitialize it again.Convert SQL to LINQ Query. Ask Question. 15. I have the following SQL query and I need to have it in LINQ, I tried several things but I can not get it working. Here is the SQL query. SELECT ST.Description, ST.STId, COUNT (SI.SIId) AS Expr1 FROM BP INNER JOIN MbrBP ON BP.BPId = MbrBP.BPId INNER JOIN SI ON BP.BPId = SI.BPId RIGHT OUTER JOIN ST ON ... ymknwdis there a sequel to horror in the high desertUsing Resharper - Turning to LINQ. Resharper is a popular but commercial tool that is used to make Visual Studio a better IDE (Integrated Development Environment). It helps to spot code errors/warnings almost instantly and therefore is a great and useful tool to improve the code quality. For example, the following C# code (Console Application ...LINQ to SQL provides a way where a developer can manage a relational database object as a .net object. In simple terms, it is an ORM (Object-relational mapping) that is used to manage a back end object as a front end object in object oriented way i.e. relational to object oriented type system.sql to c# linq converter online. Home / Codes / sql. 0. sql to c# linq converter online. Copy. sql. linq. Favourite Share. By Marian Wilkinson at Mar 15 2021. Related code examples. sql online compiler. sql online code. sql to mongodb query converter. online sql testing tool. join in linq c#. c# left join linq.Nov 19, 2007 · SQL syntax can differe a bit among different versions, but here’s an example for instance: SQL. SELECT Name CustomerName, CustomerID ID. FROM Customers. ORDER BY ID. The basic syntax for a VB LINQ expression is also a series of “clauses”, of which the first is a From Clause (or Aggregate Clause, but we’ll get to that later). Depending on your model you could perhaps use navigation properties rarher than joins. IMHO it's best to forget about the SQL statement. When using Linq it's likely best to adopt a C# rather than a SQL point of view (ie you are working with objects and collections, not with relational data). Aug 27, 2009 · I tried linqpad but its not for converting SQL to linq but its actual use is to replace sql with linq to query your database however I think linqer is the right choice if you like to convert SQL query to LINQ. Visit LINQ Tutorials to learn LINQ step by step. The DbSet class is derived from IQuerayable. So, we can use LINQ for querying against DbSet, which will be converted to an SQL query. EF API executes this SQL query to the underlying database, gets the flat result set, converts it into appropriate entity objects and returns it as a query result.First off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. SQL syntax can differe a bit among different versions, but here's an example for instance: SQL. SELECT Name CustomerName, CustomerID ID. FROM Customers. ORDER BY ID. The basic syntax for a VB LINQ expression is also a series of "clauses", of which the first is a From Clause (or Aggregate Clause, but we'll get to that later).using ( var ctx = new SchoolDBEntities ()) { var studentList = ctx.Students .SqlQuery ( "Select * from Students" ) .ToList< Student > (); } The above query executes Select * from Students SQL in the database to get all students and will be converted into a list of Student entities. The column names in the SQL query must match with the ...It does, however, have an Any method, which accomplishes the same thing. Here's the code for excluding records with LINQ's Any method: var noServiceCalls = from a in _context.Apartments where !_context.ServiceCalls.Any (s => s.ApartmentID == a.ID) select a; You can see the direct connection between this and our SQL. 200 cigarettes duty free price uk 2022 More importantly: when it comes to querying databases, LINQ is in most cases a significantly more productive querying language than SQL. Compared to SQL, LINQ is simpler, tidier, and higher-level. It's rather like comparing C# to C++. Sure, there are times when it's still best to use C++ (as is the case with SQL), but in most situations. abap ... First off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. A LINQ to SQL query gets sent to the database only when the program needs to read data. For example , the following foreach loop iterates rows returned from a table: var query = from c in Customers where c.Country == "USA" select c.CompanyName; foreach ( var company in query ) { Console.WriteLine ( company ); }. "/> Jan 31, 2008 · Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst) November 28, 2007. VBTeam. This post assumes you’ve read Converting SQL to LINQ, Part 1: The Basics. I’ve made the following name changes since the last post, which I hope will make the code examples clearer: · Customers -> CustomerTable · Orders -> OrderTable · cust -> Contact ... Aug 27, 2009 · I tried linqpad but its not for converting SQL to linq but its actual use is to replace sql with linq to query your database however I think linqer is the right choice if you like to convert SQL query to LINQ. The goal of Linq To SQL is to create an interface independent from the database engine that the application will be using. This will greatly simplify the work and the data interactions as well. Here is how it goes! 1. Setup the Environment. The first step in using Linq To SQL is to create a real SQL database.Sep 15, 2021 · LINQ to SQL itself translates all the necessary operations into the necessary SQL operations that you are familiar with. For more information, see LINQ to SQL. In the following example, the company names of customers from London are retrieved and displayed in the console window. // Northwnd inherits from System.Data.Linq.DataContext. I have a LINQ to SQL query from EF that has the following WHERE condition (ignore the redundant DateTime.Parse, those are just placeholders for … Press J to jump to the feed. Press question mark to learn the rest of the keyboard shortcuts top 2022 nfl rookie running backs from a in Answers group a by a.QuestionID into grouping join a2 in Answers on new {AnswerID = grouping.Max (x => x.AnswerID), QuestionID = grouping.Key} equals new {a2.AnswerID, a2.QuestionID} select a2 Makes me wonder in what way Linq2Sql is supposed to be simpler than SQL. AndomarLINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources. In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer. When the application runs, LINQ to SQL translates into SQL the language-integrated queries in the object model and sends them to the database for execution.Full Linq to Sql Support. Utilize the full power of the LLBLGen Pro Designer when working with with your entity model: use reverse-engineering functionality (Database first) or Model first tools at the same time. Easily synchronize your entity model with the database schemas, define and validate your entity model or create derived models on top of them and much more.Nov 21, 2021 · I think you need to find a tag for LINQ or Entity Framework. It would also be a good idea to add some context to your question. Right now you are in an SQL Server forum, and many of us here consider LINQ to be a dirty word. Sep 16, 2020 · An SQL-> LINQ converter. Or LINQPad: linqpad. BR, Mia. If the answer is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our ... Feb 26, 2018 · Solution 14. SELECT CAST (a.FechaIngreso AS DATE),p.Apellido, SUM (CASE WHEN ag.Id is NULL THEN 0 ELSE 1 END) AS Generales, SUM (CASE WHEN ld.Id is NULL THEN 0 ELSE 1 END) AS Leyes, SUM (CASE WHEN aa.Id is NULL THEN 0 ELSE 1 END) AS ModificadoGenerales, SUM (CASE WHEN ald.Id is NULL THEN 0 ELSE 1 END) AS ModificadoLeyes. FROM dbo.Avisos a. LINQ to SQL is smart enough to know that if a row is inserted and then deleted (or the other way around) nothing needs to be done. If you look at the ChangeSet after running this function, you will notice that the Inserts and Deletes collections are empty. Updates are a little more annoying.SQL syntax can differe a bit among different versions, but here's an example for instance: SQL. SELECT Name CustomerName, CustomerID ID. FROM Customers. ORDER BY ID. The basic syntax for a VB LINQ expression is also a series of "clauses", of which the first is a From Clause (or Aggregate Clause, but we'll get to that later).How to use SQL wildcard character (i.e % )in C# LINQ Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join themThis example defines the basic idea of LINQ to SQL Query using code. Step 1 Open visual studio 2010 and create a new project -> Web -> ASP.NET Web Application. Step 2 Once project is load we need to create a database. Right Click the App_data -> Add -> New Item. Step 3 Now select SQL server Database. Step 4May 29, 2011 08:10 AM in sql it's extremely simple to write an insert into select where query, e.g insert into tableA select columnA where columnB = '1' but i cannot find any way to do this in LINQ to SQL cna someone please help?? Please be patient if say anything really dumb, I'm self-taught but I'm trying!GUI Code Viewer is Edit Area © by Christophe Dolivet ...Query expression is nothing but a LINQ query, expressed in a form similar to that of SQL with query operators like Select, Where and OrderBy. Query expressions usually start with the keyword "From". To access standard LINQ query operators, the namespace System.Query should be imported by default.Depending on your model you could perhaps use navigation properties rarher than joins. IMHO it's best to forget about the SQL statement. When using Linq it's likely best to adopt a C# rather than a SQL point of view (ie you are working with objects and collections, not with relational data). craigslist tucson rvs for sale by ownerPlease help me to convert this SQL query in LINQ-Enitites. select *,b.Quantity - (Select SUM(a.Quantity) from PurchaseDetail a join PurchaseMaster c on a.PurchaseId=c.PurchaseId join PurchaseOrderMaster d on c.PurchaseOrderId=d.PurchaseOrderId where a.RawMetId=b.RawMetrialId) as Remain from PurchaseOrderDetail bThe LINQ to Entities allows us to write queries (known as LINQ Queries) in C# and VB.NET. These LINQ queries are then transferred into the Expression Tree. The Database Provider ( Entity Client in EF6) will then use the Entity Model to translate LINQ Queries into the SQL query. The SQL query is then sent to the database using the Command object ...LINQ to SQL is smart enough to know that if a row is inserted and then deleted (or the other way around) nothing needs to be done. If you look at the ChangeSet after running this function, you will notice that the Inserts and Deletes collections are empty. Updates are a little more annoying.A free PDF library that can be used to create, read, edit, convert and print PDF files within any .NET ( C#, VB.NET, ASP.NET, .NET Core) application. A free barcode library which is designed to generate and read most common 1D & 2D barcodes from any .NET applications.Please help me to convert this SQL query in LINQ-Enitites. select *,b.Quantity - (Select SUM(a.Quantity) from PurchaseDetail a join PurchaseMaster c on a.PurchaseId=c.PurchaseId join PurchaseOrderMaster d on c.PurchaseOrderId=d.PurchaseOrderId where a.RawMetId=b.RawMetrialId) as Remain from PurchaseOrderDetail bLINQ to SQL provider translates the LINQ query into T-SQL that the SQL Server database can understand 3. SQL Server executes the query, and returns the matching rows 4. LINQ to SQL provider creates... netflix indir macLINQ to SQL LIKE Operator By using Contains (), StartsWith (), EndsWith () we can implement LIKE operator in LINQ to SQL. like '%SearchString%' = Contains ("SearchString") like '%SearchString' = StartsWith ("SearchString") like 'SearchString%' = EndsWith ("SearchString") Input tables Employees table Zoom -in LINQ Query Contains ():Solutions on MaxInterview for sql to c 23 linq converter online by the best coders in the worldLINQ to SQL performs a check whether this call was executed in the scope of the Transaction started by user (local or distributed), when SubmitChanges is called. It is executed in the context of the same transaction, if the DataContext.Transaction property is set to a DbTransaction instance. Please note, that you should either commit or ...Within Filter Query field of "Get rows" action, type the following formula: year (date1) ge 2018 and month (date1) ge 02 and day (date1) ge 12. The flow works successfully as below: When working with date value, we should get year, month and day separately.To accomplish this task successfully, first open your project in the solution explorer, right click->add->new item, in the 'data' categories, there is a type named 'LINQ To SQL Classes'. Select that. We will get a .dbml file created along with designer interface.Depending on your model you could perhaps use navigation properties rarher than joins. IMHO it's best to forget about the SQL statement. When using Linq it's likely best to adopt a C# rather than a SQL point of view (ie you are working with objects and collections, not with relational data). First off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. Best SQL to XML Converter, Parser, Transformer Online Utility. Load form URL,Download,Save and Share.Apr 03, 2016 · Linqer is a SQL to LINQ conversion tool. It helps learning LINQ and convert existing SQL statements. Not every SQL statement can be converted to LINQ, but Linqer covers many different types of SQL expressions. Linqer supports both .NET languages - C# and Visual Basic. Because LINQ is a part of the C# and VB languages, it is sensitive to data ... Nov 21, 2021 · I think you need to find a tag for LINQ or Entity Framework. It would also be a good idea to add some context to your question. Right now you are in an SQL Server forum, and many of us here consider LINQ to be a dirty word. tb42 efi reliability xa