![use razorsql to create scripts use razorsql to create scripts](https://i0.wp.com/images.sftcdn.net/images/t_app-cover-l,f_auto/p/dc27b1f6-9b2a-11e6-92cd-00163ed833e7/1317772843/razorsql-screenshot.png)
It is straightforward to create the data modules, decide on the schema, and choose how it appears to the users. This database solution requires no coding to build apps on the back end and front end. Knack is a SaaS-based online DBMS that allows users to quickly build business apps, automate workflows, manage data, and easily build web apps. For example, Atlas Compass doesn't allow users to view or switch between two data collections simultaneously. The data access and lookup tools have limited functionality. MongoDB is NoSQL and doesn't support joins, which can make data retrieval harder in some cases. MongoDB is easy to learn and understand, making it ideal for group projects and team rotations. MongoDB's API allows system integration with third-party solutions, such as Tableau, Microsoft Power BI, and Qlik. Integration with third-party solutions.Allows administrators to run queries, monitor index usage, manipulate data, and create data graphs to monitor performance. MongoDB allows database administrators to set up role-based access rights, dedicated firewalls, authorization protocols, and TLS (transport layer security) encryption. Developers can build deployment clusters based on the usage region, instance size, and memory requirements. This DBMS allows developers to build applications and utilize the built-in tools to visualize, manipulate, and analyze data. Hence we have two separate methods.MongoDB stores data in JSON-like documents. Performing a delete operation in response to a Get request (or for that matter, performing an edit operation, create operation, or any other operation that changes data) opens up a security hole. When we click on Delete button on this page, it will send a Post request to delete the record which is handled by the OnPost method. When we click on Delete link on the EmployeeIndex page, it will send a Get request and return a View of the employee using OnGet method.
![use razorsql to create scripts use razorsql to create scripts](https://razorsql.com/images/articles/oracle_mysql_conversion.png)
Note that we have two methods, OnGet and OnPost in.
![use razorsql to create scripts use razorsql to create scripts](https://i1.wp.com/www.fullsoftzone.com/wp-content/uploads/2018/11/RazorSQL-latest-versio.png)
SqlCommand cmd = new SqlCommand(sqlQuery, con).string sqlQuery = "SELECT * FROM tblEmployee WHERE EmployeeID= " + id.public Employee GetEmployeeData( int ? id).SqlCommand cmd = new SqlCommand( "spUpdateEmployee" , con).public void UpdateEmployee(Employee employee).//To Update the records of a particluar employee.SqlCommand cmd = new SqlCommand( "spAddEmployee" , con).public void AddEmployee(Employee employee).
![use razorsql to create scripts use razorsql to create scripts](https://images.squarespace-cdn.com/content/v1/576dc6d2579fb313163ccfa0/1555600359005-04CZGP5LQ2O7YJ5T7GIU/Screen+Shot+2019-04-16+at+4.23.55+PM.png)
SqlDataReader rdr = cmd.ExecuteReader().SqlCommand cmd = new SqlCommand( "spGetAllEmployees" , con).using (SqlConnection con = new SqlConnection(connectionString)).string connectionString = "Your Connection string here".