browse.develop.com
Browse.develop.com is a community that was established to collect and organize valuable web information. Our technical staff have selected and indexed information and courses that they feel will help you stay current on best practices across the SDLC.

20 Articles match "LINQ","Query"

Related DevelopMentor Courses MORE
Essential LINQ with the Entity Framework
Learn to combine flavors of LINQ to query and transform in-memory collections, XML data sources, and relational databases. Learn to develop applications for EF and LINQ to Entities and employ ADO.NET Data Services to integrate data from the Internet cloud. You'll get answers to these questions: When should I use LINQ instead of "classic" ADO.NET? How is LINQ to Entities different from LINQ to SQL? How can I use stored procedures with LINQ to retrieve and update relational databases? LINQ to Objects The central feature of.NET 3.5
DevelopMentor Courses - Friday, June 12, 2009
READ MORE
Essential LINQ with the Entity Framework 4.0
including extension methods and lambda expressions Use LINQ to filter, sort, and group in-memory collections of objects Create LINQ to Entities queries to execute stored procedures and perform updates in real-world database applications Write LINQ to XML queries to search XML documents and save them to the file system Build a rich conceptual entity model using the EF and to visually map it to a database schema Learn how to implement Repository and Unit of Work design patterns with EF 4.0 How is LINQ to Entities different from LINQ to SQL?
DevelopMentor Courses - Monday, October 12, 2009
READ MORE
Web Development Featuring LINQ, AJAX, ASP.NET & MVC Training
Web Development Featuring LINQ, AJAX, ASP.NET & MVC is an examination of Microsoft's recent innovations in web development. jQuery Visual Studio 2008 IIS 7 Silverlight 2 Internet Explorer 8 ASP.NET Model View Controller (MVC) You'll get answers to these questions: What is LINQ and can I use it in ASP.NET? LINQ to Objects We examine the Enumerable library which is the foundation for LINQ to Objects. We see the various query semantics supported, such as filtering, sorting, grouping, aggregates, and joins. What new controls have been added in ASP.NET 3.5?
DevelopMentor Courses - Wednesday, June 2, 2010
READ MORE

33 Articles match "LINQ","Query"

The Latest from DevelopMentor MORE
MongoDB vs. SQL Server 2008 Performance Showdown
This article is a follow up one I wrote last week entitled “The NoSQL Movement, LINQ, and MongoDB - Oh My!”. In that article I introduced the NoSQL movement, MongoDB, and showed you how to program against it in.NET using LINQ and NoRM. If your application is data intensive and stores lots of data, queries lots of data, and generally lives and breathes by its data, then you’d better do that efficiently or have resources (i.e. Users will interact with the data by having nearly as many inserts as they do queries. Query Speed Comparison. Those were. Performance.
Michael C. Kennedy's Weblog - Thursday, April 29, 2010
READ MORE
The NoSQL Movement, LINQ, and MongoDB - Oh My!
Interact with the database using LINQ. Shortly we’ll look at an example where we build out a disconnected, offline RSS reader that uses MongoDB and LINQ to store its data. But just think about how you might structure your data storage if you could save entire object graphs and still query them? Then your *entire* query to pull all the details of a single blog would hit a single “table” in the database. That might look like this query which has one result: var blog =. Then we’d use LINQ to SQL or Entity Framework to generate the ORM classes. Insanity!”
Michael C. Kennedy's Weblog - Thursday, April 22, 2010
READ MORE
WCF Data Services versus WCF Soap Services
All you have to do for a.NET client is simply write a LINQ query, and Data Services will translate it to a URI sent to the service. Someone recently asked me this question: When a company that has been using 2 tiers wants to move to n-tier, what are the considerations for choosing WCF and STEs [or Trackable DTOs] vs. WCF Data Services? m going to steal an image from the.NET Endpoint blog , because it shows how each programming model rests on top of the infrastructure provided by WCF. Whether that’s good or bad depends entirely on your point of view. Sweet. and WCF Data Services 4.0
Tony and Zuzana's World - Tuesday, April 13, 2010
READ MORE
  • The Best from DevelopMentor MORE
  • LINQ to SQL SubmitChanges()
    var query = from p in db.Products. select p; foreach ( var product in query). {. Tags: LINQ The DataContext.SubmitChanges() method will update the database in the following order: - Perform all inserts. Perform all updates. Perform all deletes. Running SQL Profiler while running the following code will first perform all inserts on product, then the updates and the deletes. Also note that SubmitChanges will perform a batch update (which is good). public void UpdateOrders(). {. using ( var db = new VideoGameStoreDBDataContext () ). {. if ( product.ListPrice > 400 ). {.
    The Blomsma Code - Sunday, November 30, 2008
    READ MORE
  • Processing Text Files with LINQ
    Pretty boring stuff, so my mind started to wander and I started thinking about the loops I was writing and how I could replace them with LINQ. With all of this information, we might write code like the following (without using any LINQ): using (StreamReader reader = new StreamReader("ratings.list", Encoding.GetEncoding("iso-8859-1"))) { bool inReport = false; Regex votesAndTitleRegex = new Regex(@"^ {6}.{10}s+(d+)s+d{1,2}.d The first thing we need is a way to convert the lines in a text file into an IEnumerable<T> –without that, LINQ won’t be possible.
    Jason Diamond - Sunday, September 7, 2008
    READ MORE
  • Dynamic Sorting with LINQ
    I’ve been working with ASP.NET MVC and LINQ recently and was working on a controller action that “returned&# a collection of objects (wrapped in a JsonResult ). The dictionary needs to hold expression trees and not “raw&# delegates in order for LINQ to SQL to be able to generate the correct query when it finally gets around to executing it. One potential problem: if orderByKey names a property that doesn’t exist on the object or a property that returns an object that LINQ to SQL can’t order by, a runtime exception will be thrown.
    Jason Diamond - Monday, September 1, 2008
    READ MORE
  • LINQ to SQL cross database queries
    After discovering that the LINQ to SQL Designer will only support tables from a single data source I set out to manually implement a cross database query using two data contexts. The result is the following query which joins orders in the OrderDB to products in the VideoGameStoreDB. var productdb = new VideoGameStoreDBDataContext (); var orderdb = new OrderDBDataContext (); var query. LINQ to SQL is unable to resolve this query, even though both databases sit on the same server. Tags: C# LINQ public List. FindOrders( string typename ). {. try. {.
    The Blomsma Code - Sunday, October 26, 2008
    READ MORE
  • The NoSQL Movement, LINQ, and MongoDB - Oh My!
    Interact with the database using LINQ. Shortly we’ll look at an example where we build out a disconnected, offline RSS reader that uses MongoDB and LINQ to store its data. But just think about how you might structure your data storage if you could save entire object graphs and still query them? Then your *entire* query to pull all the details of a single blog would hit a single “table” in the database. That might look like this query which has one result: var blog =. Then we’d use LINQ to SQL or Entity Framework to generate the ORM classes. Insanity!”
    Michael C. Kennedy's Weblog - Thursday, April 22, 2010
    READ MORE
  • LINQ to SQL to remain alive a little longer? LINQ to SQL changes in.NET 4.0
    I guess the success for LINQ to SQL makes it hard for Entity Framework to absorb the full feature set in a single (v2) release. Here is the list as posted by Damien : LINQ to SQL changes in.NET 4.0. Query plans are reused more often by specifically defining text parameter lengths. Reduced query execution overhead when DataLoadOptions specified (cache lookup considers DataLoadOptions value equivalency – post beta 1). Support list initialization syntax for queries. LinqDataSource support for Dynamic Data query extenders added. Query stability.
    The Blomsma Code - Tuesday, June 2, 2009
    READ MORE
  • LINQ to SQL Designer supports just one connection
    The LINQ to SQL Designer supports just one connection, which makes sense since a LINQ DataContext is scoped to one connection. The designer does offer to change the connection string for you, but I guess making cross database queries is not possible using the designer. Tags: C# LINQ The following message is what you get when dragging a table from a second data source onto the design surface.
    The Blomsma Code - Sunday, October 26, 2008
    READ MORE