Metadata FILE_IDEX SQL function

1. Usage of FILE_IDEX

SQL Server Query 1

            
 SELECT FILE_IDEX('Northwind') AS 'File_ID'  

 union all  

 SELECT FILE_IDEX((SELECT TOP (1) name FROM sys.database_files WHERE type = 1)) AS 'File_ID';   

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new FILE_IDEX("Northwind"), "File_ID")  

     .UnionAll(new SqlQueryBuilder()  

         .Select()  

         .Column(new FILE_IDEX(  

                 new SqlQueryBuilder().Select().Top(1)  

                     .Column("name", "name")  

                     .From("sys.database_files")  

                     .Where(new Where(new Column("type").Equale(1)))  

             ), "File_ID")  

     )  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT FILE_IDEX(@pMAIN_2507192009577730610) AS File_ID
UNION ALL
SELECT FILE_IDEX((SELECT TOP 1 name AS name
                  FROM sys.database_files
                  WHERE type = @pMAIN_2507192009577730611)) AS File_ID;


            
        

Parameters (If used)

Query Results 1: