Robo3T formerly known as RobMongo is one of best GUI tools for the managing and querying MongoDB database. I have been using it quite often for creating applications with MongoDB and Node.js. Recently a new version made available but there were no instructions for installing it on Ubuntu. So I thought it would be a
In this post we are going to learn how we can use NHibernate in ASP.NET MVC application. ORMs(Object Relational Mapper) are quite popular this days. ORM is a mechanism to map database entities to Class entity objects without writing a code for fetching data and write some SQL queries. It automatically generates SQL Query for
Here is the Stored Procedure code for importing comma seperated CSV files to table. CREATE PROCEDURE [dbo].[sp_ImportScript]@filepath varchar(2000)ASBEGIN TRYdeclare @tmpsql varchar(3000)set @tmpsql=’BULK INSERT table’set @tmpsql=@tmpsql + ‘ FROM ”’ + @filepath + ””set @tmpsql=@tmpsql + ‘ WITH (FIRSTROW=2,FIELDTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘,ROWTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘)’EXEC(@tmpsql)select @@rowcountEND TRYBEGIN CATCHDECLARE
Few days back Microsoft has announced it’s new next generation free mail services windows live mail. Microsoft has announces full version of it. Microsoft also giving beta tester logo for those who have used the Microsoft live beta version of mailing services.
Copyright @2024 Dotnetjalps