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

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?