none
Entity Framework 4.0 RRS feed

  • Question

  • Hi guys,

     

    In my last few projects i have use ADO.NET Entity Framework for connect with database. I have found some of the problems with entity framework from my own, like:

    • We can not do Bulk insert and Update with Entity Framework
    • If we use one function for INSERT, then we have to write both the DELETE and UPDATE function.

    Is the above points are correct or i have made some mistake and face these type of problems.

    Please also point out the other demerits of ADO.NET Entity Framework........

     

    Thanx

    • Moved by CoolDadTx Monday, December 12, 2011 3:17 PM EF related (From:Visual C# General)
    Monday, December 12, 2011 10:11 AM

Answers

  • Hi Ayan,

    Welcome to MSDN Forum!

    Based on the problems, first, the EF may could not do bulk insert and update, but we have some workarounds, here's a good sample to do the bulk operation in EF:http://archive.msdn.microsoft.com/LinqEntityDataReader; second, I think you mean stored procedure mapping, if you only want to map a insert stored procedure, you can import a stored procedure to a function in Entity Framework, here's a link can help you to learn more about it: http://msdn.microsoft.com/en-us/library/bb896231.aspx

    The Entity Framework exists as a new part of the ADO.NET family of technologies.

    1. Can easily create DAL/BL against your DB.

    2. Updating your EDM based on your DB changes would take less rather than the conventional methods.

    3. SQL Queries are good if you don't complicate your LINQ to EDM queries.

    4. IQueryable objects very good...

    5. Lamda Expressions cool...

    6. LINQ to EDM queries

    The new Technology may not perfect now, but it will impove and become a perfect technology some day.

    Best Regards

     


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, December 14, 2011 2:33 AM
    Moderator

All replies

  • Hi Ayan,

    Welcome to MSDN Forum!

    Based on the problems, first, the EF may could not do bulk insert and update, but we have some workarounds, here's a good sample to do the bulk operation in EF:http://archive.msdn.microsoft.com/LinqEntityDataReader; second, I think you mean stored procedure mapping, if you only want to map a insert stored procedure, you can import a stored procedure to a function in Entity Framework, here's a link can help you to learn more about it: http://msdn.microsoft.com/en-us/library/bb896231.aspx

    The Entity Framework exists as a new part of the ADO.NET family of technologies.

    1. Can easily create DAL/BL against your DB.

    2. Updating your EDM based on your DB changes would take less rather than the conventional methods.

    3. SQL Queries are good if you don't complicate your LINQ to EDM queries.

    4. IQueryable objects very good...

    5. Lamda Expressions cool...

    6. LINQ to EDM queries

    The new Technology may not perfect now, but it will impove and become a perfect technology some day.

    Best Regards

     


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, December 14, 2011 2:33 AM
    Moderator
  • Hi Allen

     

    Thanks for the reply.

    May be the Entity Framework is not perfect but i have enjoyed work with Entity Framework. Its really very cool.

     

    Thanks

    Ayan Choudhury

    Friday, December 23, 2011 5:02 AM