dmitri_sps wrote:
Quite often, a year after I had finished some code and needed to return to it, without proper comments, I was just staring at it and thinking, "yeah, it looks like my code, but what was the point of having this < whatever >? There had to be one"
A YEAR later? How about 2 weeks later :omg:
Jason Brown C# Developer
DOH!!! :-O :-O :-O :-O var bids = from bp in dc.BID_PROJECTs join company in dc.COMPANies on bp.Company_URN equals company.URN join pm in dc.EMPLOYEEs on bp.Management_Team_URN equals pm.URN select new { bp.BP_BPR, bp.BP_Title, bp.BP_Status, bp.BP_Type, CompanyName = company.Name, PMName = pm.Name };
Jason Brown C# Developer
Hi, I have a smallish database that is used to record bids and projects. I am new to data access development and LINQ so please forgive me if this is a daft question. :-O I am attempting to use LINQ to SQL to create a set of columns for populating a DataGridView using fields from multiple tables. My LINQ query is as follows: var bids = from bp in dc.BID_PROJECTs join company in dc.COMPANies on bp.Company_URN equals company.URN join pm in dc.EMPLOYEEs on bp.Management_Team_URN equals pm.URN select new { bp.BP_BPR, bp.BP_Title, bp.BP_Status, bp.BP_Type, company.Name, pm.Name }; The problem I am having is that both company and pm have 'Name' columns which causes Visual Studio to return the following when I attempt to compile: 'An anonymous type cannot have multiple properties with the same name' I have spent a long time looking for ways round this but to no avail, can I just apply an alias to one of the .Name properties? Thanks Jason
Jason Brown C# Developer
Funny, yet strangely disturbing :omg: What's with the hair? Does this guy want to be Britney?
Jason Brown C# Developer
I bought an Asus L3800C 5 years ago in Melbourne, thats still working fine to this day so I would heartily recommend the Asus range of laptops. Not sure on spec but just make sure it takes lots of RAM. My old Asus was the only one on the market that to took 1GB RAM back then, came with 512MB as standard. :-D
Jason Brown C# Developer
Resharper, it's well featured, reliable and doesn't cost masses of resources to use. It's even reasonably priced. http://www.jetbrains.com/resharper
Jason Brown C# Developer
.MYN (Meddle Ye Not!) .PDF (Programmer Decapitates Fiddlers) Yes I know PDF is already taken :laugh:
Jason Brown C# Developer
Hmmm, my first computer was a Sinclair ZX-81 when I was 11 (1982), i had a 16k RAM pack for it that if you breathed too heavy nearby would thow a hissy fit and crash the computer losing whatever you had been doing since it last crashed, or, if you were very lucky, since it had been switched on. This was made worse by the fact that I didn't have a compatible tape recorder to save what I had been doing. From the ZX-81 I went on to get a much more refined and stable Commodore 64. Those were the days :laugh: Jason Brown C# Developer
Koszyk wrote:
Have you used some add-on tools like Refactor
I use VS 2003 with Jetbrains Resharper and have been for well over 18 months. The resharper refactoring tools are excellent, it also has extended intellisense and vastly improved syntax highlighting. The other thing it does very well is let you know if you have variables declared but not initialised or initialised but never used. It does this by displaying orange markers next to the scroll bar. If it detects a line that is incomplete, eg missing a semicolon in C#, it displays a red marker. I was told Microsoft actually bought resharper from jetbrains to put into VS2005, from what I have seen of VS2005, and I admit that I haven't used it much, a lot of the things I use regularly have been removed or buried so deep as to be too much hassle to use. I also love the keyboard shortcuts provided by resharper. For example, highlight some code, press ctrl + alt + j which provides a shortcut menu for surround with. If I then hit 1 I get an if block, 2 I get a while block, 3 I get a for block, 6 I get a #region surround, you get the idea. It also provides a custom stack trace with hyperlinks to the areas of code listed. Resharper Details Here FYI I am in no way affiliated with Jetbrains, I just find this product makes my life as a developer much easier. Jason Brown C# Developer