DotNetShoutout

ADO.NET

8
shouts

Shout it

HanselMinutes - Show #205 - Open Data Protocol (OData) with Pablo Castro

published 2 days, 17 hours, 1 minute ago posted by

mithu 4 days, 11 hours, 4 minutes ago

HanselMinutes - Show #205 - Open Data Protocol (OData) with Pablo Castro

Astoria, ADO.NET Data Services and OData - what's the difference and the real story? How does OData work and when should I use it? When do I use OData and when do I use WCF? Scott gets the scoop from the architect himself, Pablo Castro. (more)

category: Podcast | clicked: 85 | comment | | source: www.hanselminutes.com

tags: ADO.NET, HanselMinutes, OData, WCF

7
shouts

Shout it

Get SQL Parameters From an Object Revisited. - .NET Development - Gal Ratner

published 21 days, 17 hours, 38 minutes ago posted by

galratner 23 days, 36 minutes ago

Get SQL Parameters From an Object Revisited. - .NET Development - Gal Ratner

I have my own custom data layer adapter. Its pretty slick and you probably know it by now if you read my blog post Move a DataReader to an Object with reflection Revisited. If you downloaded and are using the file ObjectHelper.cs you probably noticed a method called GetSQLParametersFromPublicProperties. This method returns an array of SqlParameters from a live object. You can use this array if you are invoking a Stored Procedure and need to send some parameters into it. Something like: publicint AddCust... (more)

category: Architecture | clicked: 27 | 1 comment | | source: galratner.com

tags: ADO.NET, Data Access Layer, data access pattern

5
shouts

Shout it

High performance bulk loading to SQL Server using SqlBulkCopy | AdaTheDev

published 24 days, 21 minutes ago posted by

AdaTheDev 25 days, 12 hours, 28 minutes ago

High performance bulk loading to SQL Server using SqlBulkCopy | AdaTheDev

If you ever want to bulk load data into an SQL Server database as quickly as possible, the SqlBulkCopy class is your friend (in the System.Data.SqlClient namespace). Since being introduced in .NET 2.0, it has provided an extremely efficient way to bulk load data into SQL Server, and is one the classes that I see as a "must know about". A usual scenario is where you want to dump some data into the database to then do some processing on. Or you want to temporarily load some data in to then query to get som... (more)

category: SQL | clicked: 13 | comment | | source: www.adathedev.co.uk

tags: ADO.NET, Performance, SQLBulkCopy, SQLServer, SQL-Server

7
shouts

Shout it

Agile ADO.Net Persistence Layer Download is on CodePlex

published 44 days, 18 hours, 21 minutes ago posted by

http://rlacovara.blogspot.com/ 48 days, 3 hours, 51 minutes ago

Agile ADO.Net Persistence Layer Download is on CodePlex

I’ve have quite a few requests for sample code so I pulled the AAPL code out of my app, put it in a stripped down ASP.Net MVC sample app and published it on CodePlex. You will need Visual Studio 2008, ASP.Net MVC Framework version 1.0, and Sql Server 2008 to run the sample app. A db backup file is included in the zip and in the source code. You can download the code at: http://aapl.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=39653 (more)

category: Agile | clicked: 12 | 1 comment | | source: rlacovara.blogspot.com

tags: ADO.NET, Business Layer, Data Access Layer, DTO

7
shouts

Shout it

Playing with C# Func and ADO.NET

posted by

http://derans.myopenid.com/ 52 days, 3 hours, 28 minutes ago

I’ve always liked the look of the generic Func and I think the possibilities behind it are awesome. However, it’s usually difficult for me to find a good place to use it. I’m probably just not that used to using it yet and I am missing out on some huge advantages. Ignorance is not bliss sometimes :) So anyhow, I was playing with the good ole ExecuteScalar & ExecuteNonQuery commands on the IDbCommand interface and came up with something kinda cool. At least I thought so… (more)

category: ASP.NET | clicked: 9 | comment | | source: derans.blogspot.com

| flag as spam

tags: ADO.NET, Func, Generics

10
shouts

Shout it

Agile ADO.Net Persistence Layer Part 4: Writing data access for new data shapes

published 51 days, 16 hours, 48 minutes ago posted by

http://rlacovara.blogspot.com/ 52 days, 14 hours ago

Agile ADO.Net Persistence Layer Part 4: Writing data access for new data shapes

I recently decided that I needed to take a fresh look at how to build a persistence architecture that would provide the flexibility of an ORM, that would embrace change instead of resist it (making maintenance code easier), and would use ADO.Net. I started building from the ground up, threw away any best practices that resulted in friction, and Agile ADO.Net Persistence Layer is the result. Part 1 in the series can be found here: Agile ADO.Net Persistence Layer Overview. What’s a new data shape? Has t... (more)

category: Architecture | clicked: 48 | comment | | source: rlacovara.blogspot.com

tags: ADO.NET, Agile, DTO

12
shouts

Shout it

The Angry .Net Developer: Agile Ado.Net Persistence Layer : Part 1 Design Overview

published 52 days, 18 hours, 10 minutes ago posted by

ali62b 53 days, 23 hours, 59 minutes ago

The Angry .Net Developer: Agile Ado.Net Persistence Layer : Part 1 Design Overview

Last year I did a blog post series on how to design a High Performance DAL using Ado.Net. Judging by the response I’ve gotten from that series, there must be a lot of developers out there who believe that even with the availability of LINQ, Entity Framework, and a host of other ORM technologies, Ado.Net is still your best option when designing a persistence layer. BTW, I’m one of them. After that series I started digging into Entity Framework and LINQ, and I was impressed by how effortless those tech... (more)

category: Architecture | clicked: 80 | comment | | source: rlacovara.blogspot.com

tags: ADO.NET

10
shouts

Shout it

Agile ADO.Net Persistence Layer: Part 3 Service Class Data Access Methods

published 53 days, 18 hours, 37 minutes ago posted by

http://rlacovara.blogspot.com/ 58 days, 13 hours, 4 minutes ago

Agile ADO.Net Persistence Layer: Part 3 Service Class Data Access Methods

When I say data access methods, I’m talking about the methods my UI is going to call whenever it needs to get data. When my Posts controller needs a list of BlogPosts to display, it’s going to call a BAL method like GetAllBlogPosts() or GetAllBlogPostsForCategory(). Last time I mentioned (over and over) that I like to keep things simple. When I need to get or save data, I don’t want to have to search through 3 different classes just to find the one with the method I need. Instead, I’m putting all my ... (more)

category: Architecture | clicked: 59 | comment | | source: rlacovara.blogspot.com

tags: ADO.NET, DTO, POCO

10
shouts

Shout it

Defining Custom Functions in Entity Framework - Gil Fink on .Net

published 74 days, 16 hours, 46 minutes ago posted by

gilf 76 days, 16 hours, 17 minutes ago

Defining Custom Functions in Entity Framework - Gil Fink on .Net

During the SDP conference I have been asked about the use of functions inside the EDM. This post will try to answer one such question of how to define a custom function in EF. (more)

category: Foundation | clicked: 70 | comment | | source: blogs.microsoft.co.il

tags: ADO.NET, Entity Framework

11
shouts

Shout it

HerdingCode - Episode 66: Brad Wilson and Scott Densmore on iPhone Development

published 85 days, 9 hours, 39 minutes ago posted by

mithu 86 days, 12 hours, 1 minute ago

HerdingCode - Episode 66: Brad Wilson and Scott Densmore on iPhone Development

What do Brad Wilson and Scott Densmore have in common? They’re expert .NET developers, a couple of Mac fanboys, and they’re both joining the guys on this week’s episode of Herding Code. Listen in while Brad and, yet another, Scott talk about the Mac, Windows, and the ins and outs of iPhone development: In case you’ve never heard of them, Brad and Scott D introduce themselves and share their interest in the Mac and iPhone development. Brad and Scott D talk about Objective-C as it compares to other lan... (more)

category: Podcast | clicked: 42 | comment | | source: herdingcode.com

tags: .NET, ADO.NET, ASP.NET MVC 2.0, C#, HerdingCode, iPhone, MVC

9
shouts

Shout it

Why You Should Use the Null Coalescing Operator

published 87 days, 16 hours, 36 minutes ago posted by

KodefuGuru 88 days, 22 hours, 28 minutes ago

Why You Should Use the Null Coalescing Operator

Introduced in C# 2.0, the null coalescing operator (??) allows one to program in a concise, declarative fashion when performing null checks. This was important in 2005 as it made it easier to utilize another important feature: nullable types. Nullable types solved the problem of representing a value type that also contained a null value. This representation of value types is common in databases, and oftentimes caused problems when doing relational to object mapping. Nullable types are generic structs t... (more)

category: Foundation | clicked: 89 | 1 comment | | source: www.kodefuguru.com

tags: ADO.NET, Generics, Linq, nullables

10
shouts

Shout it

Applying an XSLT Transform to a DataSet

published 112 days, 9 hours, 51 minutes ago posted by

http://quachnguyen.myopenid.com/ 114 days, 13 hours, 25 minutes ago

The WriteXml method of the DataSet enables you to write the contents of a DataSet as XML data. A common task is to then transform that XML to another format using XSL Transformations (XSLT). However In .NET, the DataSet is synchronized with the XmlDataDocument which enables you to apply an XSLT stylesheet to the contents of a DataSet without having to first write the contents of the DataSet as XML data using WriteXml. Let’s get started with small C# and VB.NET console application. The following e... (more)

category: ASP.NET | clicked: 106 | comment | | source: code2code.info

tags: ADO.NET

12
shouts

Shout it

Connecting to SQL Azure Using ADO.NET in F# - Matt

published 122 days, 20 hours, 33 minutes ago posted by

Steves 123 days, 14 hours, 43 minutes ago

Connecting to SQL Azure Using ADO.NET in F# - Matt

This is a very straightforward port of SQL Azure code from msdn: open System open System.Collections.Generic open System.Linq open System.Text open System.Data.SqlClient open System.Data // Provide the following information let userName = " (more)

category: Architecture | clicked: 45 | comment | | source: www.mattssoftwareblog.com

tags: ADO.NET, Azure, F#, FSharp, SQL, SQL Azure

13
shouts

Shout it

Working with Large Databases in Entity Framework - Gil Fink on .Net

published 123 days, 21 hours, 5 minutes ago posted by

gilf 125 days, 16 hours, 3 minutes ago

Working with Large Databases in Entity Framework - Gil Fink on .Net

Yesterday I was asked by a colleague a very good EF question. The question was how to split a model or how create a model for a large database. (more)

category: Foundation | clicked: 95 | comment | | source: blogs.microsoft.co.il

tags: ADO.NET, ADO.NET ENTITY FRAMEWORK, Entity Framework

12
shouts

Shout it

Understanding ASP.Net : A Complete Overview | SolidDotNet.com

published 129 days, 18 hours, 7 minutes ago posted by

http://neerajmathur.myopenid.com/ 130 days, 13 hours, 20 minutes ago

Understanding ASP.Net : A Complete Overview | SolidDotNet.com

Understanding ASP.Net : A Complete Overview with presentations... Introduction to Visual Studio Application and Page Frameworks GUI Controls Validation Server Controls Working with Master Pages Themes & Skins Collections & Lists Data Binding Data Management with ADO.Net Working with XML Site Navigation Security State Management Caching Debugging & Error Handling File I/O & Streams Configurations (more)

category: ASP.NET | clicked: 54 | comment | | source: www.soliddotnet.com

tags: ADO.NET, ASP .NET, Master Page, XML

14
shouts

Shout it

Move a DataReader to an Object with reflection Revisited - .NET Development - Gal Ratner

published 129 days, 18 hours, 7 minutes ago posted by

galratner 130 days, 15 hours, 59 minutes ago

Move a DataReader to an Object with reflection Revisited - .NET Development - Gal Ratner

if you have read my article Move a DataReader to an Object with reflection where i explain how to move a row from a DataReader into a custom object. Mapping the query fields into object properties, you may have noticed the rigidity of the code. You needed to have the exact numcers of fields in the query without any NULL values. I have since refactored the code to be more loose. using System; using System.Data.SqlClient; using System.Reflection; using System.Collections.Generic; using System.Linq; u... (more)

category: Architecture | clicked: 38 | comment | | source: galratner.com

tags: ADO.NET

12
shouts

Shout it

LINQ shortcut when using Silverlight and ADO .NET Data Services - Stephen Forte

published 132 days, 10 hours, 21 minutes ago posted by

Steves 133 days, 23 hours, 42 minutes ago

LINQ shortcut when using Silverlight and ADO .NET Data Services - Stephen Forte

I have a simple demo application that uses ADO.NET Data Services as a data service back end for a Silverlight application. My ADO.NET Data Service uses the Entity Framework to map the Northwind database tables of Customers, Orders, and Order Details. Once the Silverlight applications sets a service reference to the ADO.NET Data Service, you can use the client side LINQ libraries to build your application. My application looks like this, it has a drop down filled with customers, a grid with Order and a g... (more)

category: Architecture | clicked: 35 | comment | | source: www.stephenforte.net

tags: ADO.NET, ADO.NET Data Service, ADO.NET Data Services, Linq, Silverlight

18
shouts

Shout it

Using C# Dynamic to simplify ADO.NET Data Access - David Ebbo

published 136 days, 22 hours, 13 minutes ago posted by

Scott 137 days, 23 hours, 45 minutes ago

Using C# Dynamic to simplify ADO.NET Data Access - David Ebbo

Recently, I started playing around with C# dynamic, and blogged how it could be used to call static class members late bound. Today, I was talking to Phil Haack, who I think had talked to ScottGu, and he mentioned that it would be cool to use dynamic to simplify data access when you work directly with SQL query. So I thought I’d play around with that, and it didn’t take much code to make it work nicely. So the scenario is that you’re not using any fanc... (more)

category: Architecture | clicked: 60 | comment | | source: blogs.msdn.com

tags: ADO.NET, ADO.NET Data Service, ADO.NET Data Services

13
shouts

Shout it

Entity Framework Free Tools List - Gil Fink on .Net

published 142 days, 1 hour, 47 minutes ago posted by

gilf 142 days, 23 hours, 49 minutes ago

Entity Framework Free Tools List - Gil Fink on .Net

In my last session at Microsoft I mentioned some EF free tools that you can use which can help you to be more productive. Since I got a comment about sharing my list, this is the free tool list and the places you can find them and download them: (more)

category: Foundation | clicked: 77 | comment | | source: blogs.microsoft.co.il

tags: ADO.NET, Entity Framework, Tools

9
shouts

Shout it

Retrieving SQL Server Runtime Statistics

posted by

http://quachnguyen.myopenid.com/ 148 days, 15 hours, 37 minutes ago

Retrieving SQL Server Runtime Statistics You want to get information about your connection to SQL Server, including bytes sent, bytes received, connection time, and execution time. The .NET Framework 2.0 added support for runtime statistics with the SQL Server data provider. Runtime statistics expose information about processing queries in the database. You must enable statistics by setting the StatisticsEnabled property of the SqlConnection object to true after the connection has been create... (more)

category: SQL | clicked: 8 | comment | | source: code2code.info

| flag as spam

tags: ADO.NET

Welcome!

Our Sponsors

The Lounge

ADO.NET

HanselMinutes - Show #205 - Open Data Protocol (OData) with Pablo Castro

Get SQL Parameters From an Object Revisited. - .NET Development - Gal Ratner

High performance bulk loading to SQL Server using SqlBulkCopy | AdaTheDev

Agile ADO.Net Persistence Layer Download is on CodePlex

Playing with C# Func and ADO.NET

Agile ADO.Net Persistence Layer Part 4: Writing data access for new data shapes

The Angry .Net Developer: Agile Ado.Net Persistence Layer : Part 1 Design Overview

Agile ADO.Net Persistence Layer: Part 3 Service Class Data Access Methods

Defining Custom Functions in Entity Framework - Gil Fink on .Net

HerdingCode - Episode 66: Brad Wilson and Scott Densmore on iPhone Development

Why You Should Use the Null Coalescing Operator

Applying an XSLT Transform to a DataSet

Connecting to SQL Azure Using ADO.NET in F# - Matt

Working with Large Databases in Entity Framework - Gil Fink on .Net

Understanding ASP.Net : A Complete Overview | SolidDotNet.com

Move a DataReader to an Object with reflection Revisited - .NET Development - Gal Ratner

LINQ shortcut when using Silverlight and ADO .NET Data Services - Stephen Forte

Using C# Dynamic to simplify ADO.NET Data Access - David Ebbo

Entity Framework Free Tools List - Gil Fink on .Net

Retrieving SQL Server Runtime Statistics

Open ID Login

Standard Login

Forgot Password?

Sign up