query to linq converter online

                
                        DataTable datatable = DatabaseAccess.Select("SELECT * FROM UsersTable WHERE Username = '" + txtUsername.Text.Trim() + "'");
                    
                

SQL to LINQ converter

                        
                                select top 10 p.Nombre, p.Apellidos, (SELECT COUNT(*) FROM Personas ps WHERE PS.ParentCode LIKE '%' + CONVERT(VARCHAR, p.id) + '-%'   ) Total  
from personas p
ORDER BY Total desc
                            
                        

Related code examples