LINQ to Oracle or Entity Framework.
Posted: Wed 09 Sep 2009 01:02
Please help me decide. I cannot choose between the two technologies:
Entity Framework:
pros: Integrated into Visual studio design tools, the library references are added automatically.
cons: Cannot handle IN clause.
LINQ to SQL:
pros: can handle the IN clause
cons: library references should be added manually,
once the classes are generated and you decide to add more tables to generated context classes you have to start from sratch by again choosing all tables (and I am choosing from hundreds of them).
Am I doing something wrong?
BTW, which one supports Oracle's hints? I have to use them sometimes.
Thanks
Entity Framework:
pros: Integrated into Visual studio design tools, the library references are added automatically.
cons: Cannot handle IN clause.
LINQ to SQL:
pros: can handle the IN clause
cons: library references should be added manually,
once the classes are generated and you decide to add more tables to generated context classes you have to start from sratch by again choosing all tables (and I am choosing from hundreds of them).
Am I doing something wrong?
BTW, which one supports Oracle's hints? I have to use them sometimes.
Thanks