Re: Can you use the OleDb classes for SQL Server?
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxx>
- Date: Fri, 6 Jul 2007 09:33:18 -0700
There are whole books on the subject and no, it's not easy to do. While I
mention the approach in my books, I don't recommend it--especially for the
inexperienced developer. Writing a data-centric application is more than
just setting up queries and returning results. It also involves managing
schemas, rights, uploads, downloads, procedures, backup, restore, exception
handling and a lot more. The exception handling alone is a monumental task
if you aren't developing against the actual database. While a data access
layer can be done, it has to be written with a clear and complete
understanding of both systems and how they interact with the low-level and
high-level interfaces.
If I were you, I would develop against the engine you expect to use during
production.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Gustaf" <gustafl@xxxxxxxxxx> wrote in message
news:OulluC7vHHA.5008@xxxxxxxxxxxxxxxxxxxxxxx
William (Bill) Vaughn wrote:
No. Oracle uses different syntax, data flow and other methodologies in
their SPs. They are not compatible with SQL Server. I would write a data
layer that uses the OracleClient .NET data provider to access Oracle.
So, to summarize, if I want to handle both SQL Server (which I need for
development) and Oracle (for deployment), I shouldn't use stored
procedures. Instead, I can write a DAL for SQL Server during development,
and then use that as a template for an Oracle DAL?
I'm not so familiar with the topic, so I hope someone can point me to an
example on how to design a DAL. What I imagine is a class with a method
that takes my business object as input, and return an error code in case
something goes wrong with the connection or the SQL command.
Gustaf
.
- References:
- Can you use the OleDb classes for SQL Server?
- From: Gustaf
- Re: Can you use the OleDb classes for SQL Server?
- From: Gustaf
- Re: Can you use the OleDb classes for SQL Server?
- From: William \(Bill\) Vaughn
- Re: Can you use the OleDb classes for SQL Server?
- From: Gustaf
- Can you use the OleDb classes for SQL Server?
- Prev by Date: datagrid to display bcp file
- Next by Date: Re: Datatables and TableAdapters in separate files
- Previous by thread: Re: Can you use the OleDb classes for SQL Server?
- Next by thread: Re: Can you use the OleDb classes for SQL Server?
- Index(es):
Relevant Pages
|
