I have list of text files in a directory and i want to read these files with their specific format files, forexample file1.txt with file1.fmt , i had done this before with openRowset syntax in sqlserver but i want its equivalent in c# or ORM, Attention that i dont want use executeSqlRaw and call sp or sqlQuery.
this is OpenRowSet in sql that i had been written

SET @SQL = N'SELECT * INTO ' + @TableName +  N' FROM' +
            N'(SELECT *
                FROM OPENROWSET(BULK ''' + @path + @filename+ + ''',
                                FORMATFILE=''' + @path + 'FORMATfile.fmt'',
                                CODEPAGE=''65001'',
                                FIRSTROW=2 
                                ) AS B) X';
                                
            EXEC (@SQL);