|
|
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.
|
8 Articles match "LINQ","Query"
|
Related DevelopMentor Courses
|
MORE
|
|
Essential LINQ with the Entity Framework
including extension methods and lambda expressions Use LINQ to filter, sort, and group in-memory collections of objects Create LINQ to SQL queries to execute SQL Server 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 Use LINQ to Entities to write strongly typed queries against the Entity Data Model Detect and resolve concurrency conflicts with both LINQ to SQL and LINQ to Entities Execute business
DevelopMentor Courses
- Friday, June 12, 2009
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 Employ Test-Driven Development methodologies with the Entity Framework Detect
DevelopMentor Courses
- Monday, October 12, 2009
Mastering .NET 3.5 featuring LINQ, WPF, WCF & WF
Use LINQ to filter, sort, and group in-memory collections of objects Create LINQ to SQL queries to execute SQL Server stored procedures and perform updates Write LINQ to XML queries to search XML documents and save them to disk Build rich client applications with XAML and WPF that run standalone or in a browser Use WPF data binding and XAML to separate your code and UI elements Build service-oriented WCF services, as well as REST-based services and RSS / ATOM feeds Manage concurrency and state with WCF and handle exceptions appropriately Design robust workflow-oriented programs with Windows Workflow
DevelopMentor Courses
- Friday, June 12, 2009
|
30 Articles match "LINQ","Query"
|
The Latest from DevelopMentor
|
MORE
|
|
Securing WCF Data Services using WIF
LINQ to query the Data Service.
This questions comes up every once in a while..
Since Since WCF Data Services is just a normal WCF service (using the web programming model),
all all the typical security APIs and extensibility points apply.
That That said, depending
www.leastprivilege.com
- Monday, February 15, 2010
EF4 compared to NHibernate
Last week while teaching my new LINQ and Entity Framework course I got a question asking me to compare EF4 with NHibernate . EF supports LINQ out of the box (NH doesn’t have it yet)
EF also allows you to define functions with Entity SQL that are embedded in the entity model, and you can execute queries and commands directly against the database, effectively doing an end-run around EF while mapping the results to entities.
Not having worked extensively with NHibernate, I wasn’t in a position to address the question. Then yesterday I received an email containing a
Tony and Zuzana's World
- Wednesday, January 13, 2010
EF 4.0 N-Tier Support: Take 2
On the service-side, I wrote a helper class which interrogated entities for changes and persisted changes to the database, using either LINQ to SQL or the Entity Framework.
public Order GetOrder( int orderId)
{
using ( NorthwindEntities ctx = new NorthwindEntities ())
{
// Eager-load related entities
var query =
from o in ctx.Orders
.Include( Following the release of Visual Studio 2010 and .NET NET 4.0
Tony and Zuzana's World
- Thursday, November 12, 2009
|
-
|
The Best from DevelopMentor
|
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):
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. I was recently writing some code to stream through a large text file, processing the lines it found that matched a regular expression. To demonstrate what I came up with, I thought I’d
Jason Diamond
- Sunday, September 7, 2008
-
LINQ to SQL SubmitChanges()
new VideoGameStoreDBDataContext ()
)
{
var query
= from p in db.Products
select p;
foreach ( var product in query)
{
product.ListPrice = product.ListPrice * 1.1;
if (
product.ListPrice Tags: LIN The DataContext.SubmitChanges() method will update the database in the following order:
- Perform all inserts
-
The Blomsma Code
- Sunday, November 30, 2008
-
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 ). Thanks to the way LINQ defers the actual execution of queries as late as possible, it’s possible to write code like the following to “dynamically” sort (using the Person.Contact table from the AdventureWorks database as an example):
Ever spend too much time working on a clever solution to a problem only to discover that your original approach was perfectly fine to begin with?
Jason Diamond
- Monday, September 1, 2008
-
LINQ to SQL cross database queries
After discovering that the LINQ to SQL Designer will only support tables from a single
data 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 new OrderDBDataContext contexts.
The the VideoGameStoreDB.
The Blomsma Code
- Sunday, October 26, 2008
-
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 LINQ
to Query plans are reused more often by specifically defining text parameter lengths
Identity Reduced query execution overhead when DataLoadOptions specified (cache lookup considers
DataLoadOptions full feature set in a single (v2) release. The team has been working on a bunch of
fixes
The Blomsma Code
- Tuesday, June 2, 2009
-
LINQ to SQL Designer supports just one connection
The LINQ to SQL Designer supports just one connection, which makes sense since a LINQ
DataContext string for you, but I guess making cross database queries is not possible using the
designer.
Tags: C# LIN DataContext is scoped to one connection. The designer does offer to change the connection
string designer.
The Blomsma Code
- Sunday, October 26, 2008
-
LINQ to SQL external mapping file
With LINQ to SQL you can choose to use an external mapping file, allowing you to map
SQL Suppliers = db.GetTable ();
var query
= Tags: C# LIN SQL statements to CLR objects (also referred to as POCO, Plain Old CLR Objects). Doing
so so
The Blomsma Code
- Saturday, October 25, 2008
|
|
|
