none
Schema First VS Model First VS Code First VS Enterprize Library (DataSet aprroach) RRS feed

  • Question

  • hi,

    I have many questions in my mind by taking the maximum performance.

    If i don't use Entity framework. then i can use ADO.NET library.

    If i use Enterprise library then i can use some better approach through dataset and could use stored procedures more dynamically.

    But if i use Entity framework.

    i have now three further flavors.

    First one is Schema First approach.    ----------- Don't think much efficient approach for enterprise system.

    Second approach is Model First Approach ------- Thinking is same as for Schema First approach.

    Third one is Code First approach ---- Thinks more better or best approach still yet.

    Isn't soo?

    What i need for it ?

    I mean for Code First approach , If i go beyound the SQL Server database?

    If i want to use MySQL , Oracle, DB2 or Sybase?

    Are there providers could help and conforms 100% like SQL Server?

    Please guide and suggest if i am wrong at somewhere.

    Thanks


    • Edited by chromeFor Monday, October 28, 2013 3:23 AM Complete
    Monday, October 28, 2013 3:20 AM

Answers

  • Hello,

    >>Are there providers could help and conforms 100% like SQL Server?

    Unfortunately, as far as I know, there is no provider released by Microsoft which will be suitable for database beyond SQLServer.

    These providers will be available on these database created.

    For Oracle:

    We can see that Oracle released its beta provider for EF: http://blogs.msdn.com/b/adonet/archive/2011/02/22/oracle-releases-beta-of-entity-framework-provider.aspx.

    The blog indicates that Oracle provider includes LINQ to Entities, Model First development, and support for the Entity Data Model Wizard.

    However, for code first, it has not been got so far.

    See it:

    https://forums.oracle.com/thread/2211863

    For others, we can find regarding information on its website.

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by chromeFor Sunday, November 3, 2013 3:56 PM
    Tuesday, October 29, 2013 6:37 AM
    Moderator
  • >>THanks then what should i use for all database?

    There is no a single provider which can be used for all database. We need use the corresponding provider by the database.

    For SQLServer,We can download the provider on:

    https://www.nuget.org/packages/EntityFramework/

    And for other databases, we can download the provider in their official website.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by chromeFor Sunday, November 3, 2013 3:56 PM
    Thursday, October 31, 2013 7:47 AM
    Moderator

All replies

  • Hello,

    >>Are there providers could help and conforms 100% like SQL Server?

    Unfortunately, as far as I know, there is no provider released by Microsoft which will be suitable for database beyond SQLServer.

    These providers will be available on these database created.

    For Oracle:

    We can see that Oracle released its beta provider for EF: http://blogs.msdn.com/b/adonet/archive/2011/02/22/oracle-releases-beta-of-entity-framework-provider.aspx.

    The blog indicates that Oracle provider includes LINQ to Entities, Model First development, and support for the Entity Data Model Wizard.

    However, for code first, it has not been got so far.

    See it:

    https://forums.oracle.com/thread/2211863

    For others, we can find regarding information on its website.

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by chromeFor Sunday, November 3, 2013 3:56 PM
    Tuesday, October 29, 2013 6:37 AM
    Moderator
  • THanks then what should i use for all database?

    Could you explain more. thanks

    Wednesday, October 30, 2013 4:54 AM
  • >>THanks then what should i use for all database?

    There is no a single provider which can be used for all database. We need use the corresponding provider by the database.

    For SQLServer,We can download the provider on:

    https://www.nuget.org/packages/EntityFramework/

    And for other databases, we can download the provider in their official website.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by chromeFor Sunday, November 3, 2013 3:56 PM
    Thursday, October 31, 2013 7:47 AM
    Moderator