LINQ to NETEZZA

Question

Does anyone know if it is possible to use LINQ to query a NETEZZA back-end?

Update: I've tried both the ODBC and OLEDB Netezza drivers, but neither work. Both give a "The selected object(s) use an unsupported data source" error.

Answer 1

We've figured out a way to do this - kinda.

We've created a custom Data Class in the DBML file that reflects the structure of the stored procedure. We then use a stored procedure on Netezza (executed via a table adapter and the Netezza OLE DB driver) to file the class.

Our DAL (data access layer) pretty much just exposes the classes in the DBML to the BLL (business logic layer), so the data class looks and behaves the same as any other LINQ class.

We can't do updates, but that's not important in this instance.