.Net Data Provider Overview

Written by Welzie

August 5th, 2010 at 4:40 pm

Posted in .Net

Tagged with ,

With no comments

Summary
This is a high level summary of the basic .Net API’s for interacting with a database. This includes a short description of each and how they relate to each other. As a developer with mainly a Java and PHP background I was unclear about how ADO.Net related to OleDb and I had no idea what was meant by the term “.Net Data Provider”. I created this because the msdn documentation is HEAVILY focused on ADO.Net and does not give a clear picture of how the many namespaces, interfaces, and classes interact. Please add comments to correct or enlighten. Note at this time the relation of .Net Providers to Nhiberante, LINQ to SQL, and Entity Framework is not covered in this post.

.Net Data Provider

System.Data

Four examples of System.Data Implementations

System.Data.SqlClient

System.Data.OleDb

System.Data.Odbc

IBM.Data.DB2.iSeries


http://msdn.microsoft.com/en-us/library/system.data.sqlclient.aspx

http://msdn.microsoft.com/en-us/library/system.data.oledb.aspx

http://msdn.microsoft.com/en-us/library/system.data.odbc.aspx

http://www-03.ibm.com/systems/i/software/access/windows/dotnet/index.html

Core Classes

  • SqlConnection
  • SqlCommand
  • SqlDataAdapter
  • SqlDataReader
Core Classes

  • OleDbConnection
  • OleDbCommand
  • OleDbDataAdapter
  • OleDbDataReader
Core Classes

  • OdbcConnection
  • OdbcCommand
  • OdbcDataAdapter
  • OdbcDataReader

Core Classes

  • iDB2Connection
  • iDB2Command
  • iDB2DataAdapter
  • iDB2DataReader

ADO.Net

  • Share/Bookmark

Strange Loop 2010 – Early Bird Registration

Written by Welzie

July 30th, 2010 at 2:53 pm

Posted in Uncategorized

Tagged with ,

With no comments

The early bird registration is about to end for the Strange Loop 2010 conference. This is the second year of the conference. The first year was awesome, hopefully they can only make it better.

Go to the site to see the speaker list, because it’s too long to list here.

http://strangeloop2010.com/speakers?

Early bird registration for Strange Loop is open until 8/6/10. Don’t miss out – sign up now for just $150 through Aug. 6th.
Prices:

Strange Loop 2009 posts

http://blog.codehangover.com/strange-loop-2009-day-1/


http://blog.codehangover.com/strange-loop-2009-day-2/

php

  • Share/Bookmark

NHibernate 2 Beginner’s Guide – Book Review

Written by Welzie

June 9th, 2010 at 12:31 am

Posted in .Net, Books

Tagged with ,

With one comment


Book on Amazon

Finally someone has written an in depth beginners book for nhibernate.  Nhibernate 2.0 Beginners Guide written by Aaron Cure is just that and more.  Wow do I sound like a car salesman.  I was a little disappointed when I read Nhibernate In Action last year, because it was more of a reference than a tutorial.  This book is definitely what the title states, which is a beginners guide.  The book contains step by step examples of how to find, setup, and use nhibernate.  I highly recommend this book to anyone wanting to learn nhibernate.  By the way I think all .netters should do just that.

Pros

Cons

Chapter Notes

  • Share/Bookmark