Using LINQ to SQL with Managed ODP.NET (Oracle)

Question

I'm using the newly released Managed ODP.NET driver from Oracle to connect to my database (see here). Connection setup is fine. I now try to use a very simple LINQ to SQL example. The problem is that I get the an ArgumentOutOfRangeException. It appears on the foreach-Statement.

My very simple object:

[Table(Name = "my_mgr.ADDRESS")]
public class Address
{
    [Column(Name = "NAME")]
    public string Surname;

    [Column(Name = "VNAME")]
    public string Forename;

    [Column(Name = "ANZ")]
    public int Anz;
}

The part of testing the query:

DataContext db = new DataContext(inst.Connection);
Table<Address> addressTable = db.GetTable<Address>();

if (addressTable != null)
{
    //"SELECT * from my_mgr.ADDRESS WHERE anz > 0";
    var query = from p in addressTable where p.Anz > 0 select p;

    foreach (var p in query)
    {
        MessageBox.Show(
            "Forename: " + p.Forename + "\n" +
            "Surname: " + p.Surname
        );
    }
}

Whereas my original SQL query was (which is actually working):

SELECT * from my_mgr.ADDRESS WHERE anz > 0

I actually searched a lot for this but I cannot find valid results since the driver is very new and it seems nobody had the problem before. I am very sure that the driver supports LINQ to SQL, as stated on this website. Sadly I'm not able to use neither the Entity Framework nor auto-generation tools provided by Visual Studio.

used to be that linq to sql was for SQL Server (not Oracle, this would require Linq to Entity). So this has changed (honestly not sure for latest incarnation)? — tbone
– tbone, Commented Feb 26, 2013 at 15:03

Leniel Maccaferri · Accepted Answer · 2013-05-30 23:36:41Z

1

Linq to SQL does not support Oracle. If you want to use ODP.NET and Linq just like linq to sql, I suggest you use ALinq. http://www.alinq.org

edited May 30, 2013 at 23:36

Leniel Maccaferri

103k48 gold badges381 silver badges495 bronze badges

answered Mar 9, 2013 at 17:29

Season Mak

92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using LINQ to SQL with Managed ODP.NET (Oracle)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related