Re: datetime type in SQL Server 2008
- From: "Mark Rae [MVP]" <mark@xxxxxxxxxxxxxxxxx>
- Date: Mon, 28 Sep 2009 09:34:12 +0100
"yqever" <yqever@xxxxxxx> wrote in message news:eDmnfQBQKHA.1268@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server 2008
cmd = new OdbcCommand
<snip>
Seriously? You're using ODBC to connect to SQL Server 2008...?
Yes. What's wrong?
ODBC was superseded *thirteen* years ago by OleDb:
http://msdn.microsoft.com/en-us/library/ms810892.aspx
http://database.ittoolbox.com/documents/odbc-vs-oledb-18150
The very first version of the .NET Framework back in 2002 introduced native
..NET data providers to replace OleDb and didn't even include ODBC natively,
which was available as a separate add-on to support very old databases for
which there were no OleDb drivers.
These days, there are native .NET data providers for all major databases,
and these run rings round OleDb in terms of performance and manageability.
Generally speaking, there is no good reason for using ODBC if OleDb is
available, and no good reason for using OleDb if a native .NET data provider
is available.
Especially with SQL Server...
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
.
- Follow-Ups:
- Re: datetime type in SQL Server 2008
- From: yqever
- Re: datetime type in SQL Server 2008
- References:
- datetime type in SQL Server 2008
- From: yqever
- Re: datetime type in SQL Server 2008
- From: Mark Rae [MVP]
- Re: datetime type in SQL Server 2008
- From: yqever
- datetime type in SQL Server 2008
- Prev by Date: Re: datetime type in SQL Server 2008
- Next by Date: Re: datetime type in SQL Server 2008
- Previous by thread: Re: datetime type in SQL Server 2008
- Next by thread: Re: datetime type in SQL Server 2008
- Index(es):
Relevant Pages
|
