Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rob Shaw 37 posts 170 karma points c-trib
    Nov 06, 2019 @ 11:07
    Rob Shaw
    0

    Creating a database view best practices

    Morning all,

    I've Composed custom tables with the new Component/Migration approach in V8 which has been awesome and easy to understand. One of the benefits of this method is that you can deploy the code to various development environments and you'll be confident that they will all be in sync.

    So my question is: can/should I do the same for relational views?

    I could of course just run up SQL Server manager and do it from there but thought I would just ask if anyone has any thoughts or experience on the matter.

    TIA

  • Rob Shaw 37 posts 170 karma points c-trib
    Nov 07, 2019 @ 13:59
    Rob Shaw
    0

    So my research shows that unlike this code to create tables:

    Create.Table<BlogPostHighFivesTableSchema>().Do();
    

    You simply just need to run your create view SQL via an Execute command instead.

    I'm hosting my site on Azure and was provided with the the following template code that checks to see if the view exists or not

    IF object_id(N'<schema_name, sysname, dbo>.<view_name, sysname, Top10Sales>', 'V') IS NOT NULL
        DROP VIEW <schema_name, sysname, dbo>.<view_name, sysname, Top10Sales>
    GO
    
    CREATE VIEW <schema_name, sysname, dbo>.<view_name, sysname, Top10Sales> AS
    <select_statement, , SELECT TOP 10 * FROM Sales.SalesOrderHeader ORDER BY TotalDue DESC>
    

    Hope this helps someone in a similar position!

Please Sign in or register to post replies

Write your reply to:

Draft