Is there other Tools similar to AutoMapper we can Use?
Dapper is an Object - Relational - Mapper, whereas AutoMapper is an Object - Object mapper. The difference is that the first translates C# code to SQL and maps the returned datasets to objects whereas AutoMapper only maps one .NET object type to another. Dapper allows you to use a single query language (C#) to query different SQL databases and dialects. This way it makes your code more portable if you want to switch between MySQL and SQL Server for example. You can think of Dapper as a set of extension methods on top of IDbConnection which allow you to write C# LINQ query against the underlying datastore instead of native SQL.
It doesn't necessarily mean that AutoMapper should always map database objects to domain objects. For example you could use AutoMapper to convert between very different object types.