Subsonic: Is it possible to use the oledb provider

When I set up a connection for Subsonic 3.0.0.4 to connect to an Oledb sql provider using the T4 Templates I get the following error: Keyword no开发者_开发技巧t supported 'provider' Can Subsonic access a database using OleDb? If so. How?

---

Which dbms do you want to use?

Since SubSonic 3 uses System.Data.Common for accessing data, it should be possible to use it with every dbms that supports ADO.net (I belive there is a OleDbProvider for ado).

But if you use a DBMS that is not supported by subsonic you have write your own DataProvider and an OleDb.ttinclude template file.

The beste starting point is to look at an existing provider:

https://github.com/subsonic/SubSonic-3.0/tree/master/SubSonic.Core/DataProviders/MySQL https://github.com/subsonic/SubSonic-3.0-Templates/tree/master/TemplateProviders

Creating your own Provider shouldn't be to hard at all. I would use a Copy&Paste approach from an existing provider and modify everything that causes some errors.

---

I would use the standard SQL to LINQ Entity spaces but I have to connect to a database for a client through their application server's specific OLEDB provider. Apparently it's doing extra work after the standard OLEDB SQL commands are sent to the server. So LINQ as far as I understand is out. I built my own CRUD classes, but it's a pain doing it this way. I just want a tool that can build the standard classed so I don't have to create the layer myself.

It's MS SQL Server 2005 on the other end.