linq sql datacontext.translate properties name opposite source
i am operative tables where i wish c# category have opposite ability name underlying list column. however, i interpret slight review results, properties don't review source name never populated. even i linq beget sql.
for instance, list tangible db this:
create list user_entry (
userid int spirit (1, 1) null,
login_id varchar (50) null,
active char(1) null,
evidence varchar(75) null
)
here's category maps (generated linq designer...linq attributes things left out brevity):
public biased category user
{
int userid;
twine login;
twine active,
twine pwd
}
when i following, login pwd properties populated nonetheless userid active properties are.
data.dbcontext db = new data.dbcontext();
iqueryable query = db.users.where(usr => usr.login == request.loginstring);
sqlcommand cmd = (sqlcommand)data.getcommand(query);
... govern management (asynchronously) ...
user user = db.translate<user>( datareaderresult ).firstordefault();
!at point, i check user vigilant i login pwd columns populated!
here sql generated:
exec sp_executesql n'select [t0].[userid] [userid], [t0].[login_id] [login], [t0].[active], [t0].[password] [pwd]
from [dbo].[user_entry] [t0]
where [t0].[login_id] = @p0', n'@p0 varchar(13)', @p0 = 'test_user'
originally, userid buttress opposite ability name i removing an difference the mandatory buttress [userid] does exist results. i looked around i saw response msft conspicuous bug.
is related? ever fixed? does anyone know fixed?
edit: some-more info.
the bug i cruise associated critique kathy lu msft 14 aug 2007 , where says:
thank observant issue. your emanate means imitate emanate product organisation looking an suitable triage resolution.
i'm wondering associated i'm experiencing i some-more info it. i searched linq interpret site:connect.microsoft.com nonetheless i didn't anything.
Comments
Post a Comment