none
Automatic generation of LINQ to SQL using database project RRS feed

  • Question

  • I have been trying to find a way to keep my LINQ to SQL up-to-date with my "sql server 2005 database project". Does anyone know of a better way to do this then deploying my separate database project, recreating LINQ to SQL dbml and refactoring my code when necessary? Thing is when working on a project the datamodel occasionally changes during development, and it makes sense that this is detected within the solution.
    Thursday, January 6, 2011 11:32 AM

Answers

  • Maybe this add-in can be useful? http://huagati.com/dbmltools/

    It doesn't sync against db projects, but can help you sync against a SQL Server database as the db changes, without having to drop+recreate the entire model.


     
       Cool tools for Linq-to-SQL and Entity Framework 4:
     huagati.com/dbmltools - Visual Studio add-in with loads of new features for the Entity Framework and Linq-to-SQL designers
     huagati.com/L2SProfiler - Runtime SQL query profiler for Linq-to-SQL and Entity Framework v4
    Tuesday, January 11, 2011 2:39 AM
    Answerer

All replies

  • Hello Edwin,

    Welcome to the MSDN Forum and thank you for posting here.

    Based on your description, what you mean is when you update your database project, your linq to sql will be update. Am I right?

    If so, how about you to try a refresh() method. if not, please show more details about your issue.

     

    Thank you for your understanding and support.

    I am looking forward to hearing from you.

     

    Best Regards,

     


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, January 10, 2011 10:23 AM
    Moderator
  • Maybe this add-in can be useful? http://huagati.com/dbmltools/

    It doesn't sync against db projects, but can help you sync against a SQL Server database as the db changes, without having to drop+recreate the entire model.


     
       Cool tools for Linq-to-SQL and Entity Framework 4:
     huagati.com/dbmltools - Visual Studio add-in with loads of new features for the Entity Framework and Linq-to-SQL designers
     huagati.com/L2SProfiler - Runtime SQL query profiler for Linq-to-SQL and Entity Framework v4
    Tuesday, January 11, 2011 2:39 AM
    Answerer
  • Jackie,

    What I meant was during development when the model changes. What you describe is when the content changes.

    Having now experimented a bit I understand it is not a feature currently available, I hope it will be in subsequent Visual Studio editions.

    Sunday, February 6, 2011 6:15 PM