how to get the sql table name from table type in linq

Question

How I can get sql table name in linq

For example : In linq my table object name is : TblUserDetail.

But this table name in sql is TblUserDetails.

Answer 1

Try this:

var model = _db.Mapping; //_db is the datacontext instance
foreach (var mt in model.GetTables())
   Console.WriteLine(mt.TableName);

This will list all sql tables' names.

Quoted from Get all table names

Answer 2

Ling2sql drops the 's' because the plural is used to identify a collection of TblUserDetails in a related entity.

Probably your TblUSer entity will have a TblUserDetails collection (assumption: you have a 1:n relationship)

Answer 3

I've provided an answer for a similar question; however, the answer is for Linq to Entities.