RE: Teched next week - Melbourne

2014-10-03 Thread Clint Colefax
Such a Dad joke, and I love it.

If you don’t mind, I am going to use that whenever someone asks me what 
happened to windows 9..

Thanks
Clint Colefax

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Grant Castner
Sent: Friday, 3 October 2014 7:08 PM
To: 'ozDotNet'
Subject: RE: Teched next week - Melbourne

Because 7 8 9


Dr Grant Castner
gcast...@outlook.com.aumailto:gcast...@outlook.com.au
0458 770 749
https://twitter.com/grantcastner
http://www.linkedin.com/pub/grant-castner/0/415/bb2

From: ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith
Sent: Friday, 3 October 2014 6:29 PM
To: ozDotNet
Subject: Re: Teched next week - Melbourne


10? Whatever happened to 9?
On 3 Oct 2014 17:06, Stephen Price 
step...@perthprojects.commailto:step...@perthprojects.com wrote:
Hey all,

I'm going to TechEd next week (Melbourne) so If anyone else is going and want 
to catch up, ping me an email or sms.

Looking forward to hearing all the new goodies in Windows 10 and .Net vNext.

cheers
Stephen
0428028599tel:0428028599





Position Available

2014-07-31 Thread Clint Colefax
My Company is looking for someone to initially help support/maintain a vb6 
legacy system. Once proficient in this system, other opportunities in .net will 
open up. Anyone interested, the position is listed on seek on the following 
link.



http://www.seek.com.au/Job/26982051



Thanks

Clint Colefax


RE: MVC Model populating from EF5

2014-05-07 Thread Clint Colefax
Have you looked at the Include method?

Thanks
Clint Colefax

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of anthonyatsmall...@mail.com
Sent: Thursday, 8 May 2014 12:30 AM
To: ozdotnet@ozdotnet.com
Subject: MVC Model populating from EF5

Trying to populate a viewmodel from ef ..i can populate the model from ef with 
no issue but how do I populate the related objects?  I'm sure it easy solution!


IssueTracker_Issues is the database table from EF

IssueTracker_IssuesTypes is the database table related to field IssueTypeId 
from IssueTracker_Issues


namespace SIMIt.Models
{
public class IssueViewModel
{


public IEnumerableIssueViewModel GetIssues()
{
var db = new SBHUBDBContext();

  //This populates IssueViewModel but want to also populate the 
related model\tables
IEnumerableIssueViewModel albums = 
db.IssueTracker_Issues.Take(5).ToList().Select(a = new IssueViewModel
  {
  IssueId = a.IssueId,
  IssueTitle = a.IssueTitle,
  IssueStatusId = a.IssueStatusId,
  IssueTypeId = a.IssueTypeId,
  IssueMemberID = a.IssueStatusId,
  IssueComments = a.IssueComments,
  IssuePriorityId = a.IssuePriorityId
  });

return albums;
}


public IssueViewModel()
{
}

public int IssueId { get; set; }
public string IssueTitle { get; set; }
public int IssueCategoryId { get; set; }
public int IssuePriorityId { get; set; }
public int IssueStatusId { get; set; }
public int IssueCreatorId { get; set; }
public int IssueOwnerId { get; set; }
public IssueTypeViewModel IssueType { get; set; }  //relation
}
}



public class IssueTypeViewModel
{
public int IssueTypeId { get; set; }
public string IssueType { get; set; }
}




Anthony Salerno | Founder | SmallBiz Australia
Innovation | Web | Software | Developers | Support
Phone  : +613 8400 4191 Email  : 2Anthony (at) smallbiz.com.au   Postal : Po 
Box 135, Lower Plenty 3093 ABN : 16 079 706 737
Website : www.smallbiz.com.auhttp://www.smallbiz.com.au/




RE: Upgrading TFS 2008 to TFS 2012

2013-06-16 Thread Clint Colefax
The initial upgrade process (migration) was pretty smooth for me when I did it 
recently, but I had a lot of issues down the track.

Some of the point of hand we had included


-   Issue in the process template were nothing would list in the 
assigned to field, had to manually edit the work item templates, this may have 
been due to the template coming initially from tfs 2005 (we had upgraded once 
before)

-  The build agent couldn't be installed on XP, and I had existing 
build servers for building vb6 assets. Had to move to win7, and get vb6 working 
there, which is not trivial

-  I upgraded away from the xml based build process, to the new 
workflow build process, has issues replicating some custom build activities 
needed for my vb6 assets. Had to compromise on a couple points there.


Can't think of anything else right now, it's been a slow gradual process for 
me, done in-between other tasks.

Thanks
Clint Colefax

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Brendan Tierney
Sent: Friday, 14 June 2013 9:49 AM
To: ozDotNet
Subject: Upgrading TFS 2008 to TFS 2012

G'day Folks,

I am researching what is required to upgrade / migrate TFS 2008 to TFS 2012. I 
note that TFS 2012 can only be installed on a 64 bit OS , so if you are on a 32 
bit OS  you cannot do an in-place upgrade, you need to migrate.

This is for a local government authority, and there is a mix of project types 
in the current TFS 2008 repository from WPF, ASP.Net, Wiforms, VB.NET C#, 
VS2005, VS2008, and VS2010 format.

I am wanting to find out if anyone else has gone down this path and what the 
experience has been like.

Regards,
Brendan Tierney
M: 0423 782 930 T: 07 5514 6231
PO Box 6243 Gold Coast Mail Centre QLD 9729


From: g...@greglow.commailto:g...@greglow.com
To: y...@yannduran.commailto:y...@yannduran.com; 
ozdotnet@ozdotnet.commailto:ozdotnet@ozdotnet.com
Subject: RE: Website title bar image
Date: Sat, 13 Apr 2013 13:49:02 +1000
Thanks Michael  Yann,

I've added one. It's a real challenge to try to have something that looks good 
in that resolution though.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.comhttp://www.sqldownunder.com/

From: Yann Duran [mailto:y...@yannduran.com]
Sent: Friday, 12 April 2013 7:01 PM
To: Greg Low; ozDotNet
Subject: RE: Website title bar image

Hi Greg,

It's called a favicon.

Yann

From: ozdotnet-boun...@ozdotnet.commailto:ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (GregLow.com)
Sent: Friday, 12 April 2013 6:30 PM
To: 'ozDotNet'
Subject: Website title bar image

Hi Folks,

What property on a website is used to configure this icon:

[cid:image001.png@01CE6B6C.D696F360]

[cid:image002.png@01CE6B6C.D696F360]

Regards,

Greg

Dr Greg Low
CEO and Principal Mentor
SQL Down Under
SQL Server MVP and Microsoft Regional Director
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
Web: www.sqldownunder.comhttp://www.sqldownunder.com/


inline: image001.pnginline: image002.png

RE: [OT] Wiki

2013-04-09 Thread Clint Colefax
Thanks Emily,

Seems the free version can't be made private, but otherwise it would have been 
perfect.

Thanks
Clint Colefax

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Emily Waghorne
Sent: Tuesday, 9 April 2013 8:48 PM
To: ozDotNet
Subject: Re: [OT] Wiki

Hi Clint,

I use Wikidot, and am very happy with it, but no idea how many users it's 
limited to.

www.wikidot.comhttp://www.wikidot.com

Emily

On 9 April 2013 08:04, Clint Colefax 
cl...@virid.com.aumailto:cl...@virid.com.au wrote:
Hi all,

I'm looking for a free hosted, private wiki. Anyone know of one? I don't need 
anything fancy, but I need it to support at least 30 users (up to 70). Most of 
the free hosted one I've found, that have private options have a limit to like 
5 users..

Thanks
[Clint_C]


inline: image001.jpg

RE: [OT] FYI, Large Dell Monitor Sale (again).

2012-06-04 Thread Clint Colefax
Anyone run these monitors in portrait for coding? I have vision of getting 3 
16:10 ratio monitors and running some in portrait, had a quick go at it at a 
friends work and for certain situations, I found it great, not sure about long 
term\for everything tho.

Thanks
Clint Colefax

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Greg Keogh
Sent: Tuesday, 5 June 2012 8:00 AM
To: 'ozDotNet'
Subject: RE: [OT] FYI, Large Dell Monitor Sale (again).

For Greg and others: If you run 2 screens move to 3 and you'll love it. Just 
find the right screens, make sure they are all exactly the same and have the 
same settings and are at the same height.

You may be right, my two screens are different resolutions, slightly different 
sizes, at different angles and there is a 2 inch gap between them. It's the gap 
that most irritating due to the frame, if only they could be tiled like paper 
-- Greg



RE: categorizing ms test tests

2011-11-21 Thread Clint Colefax
If this is all you're after, you don't need resharper to do this, vs's
interfaces do exactly the same thing.

 

 

 

Thanks

Clint Colefax

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Wallace Turner
Sent: Tuesday, 22 November 2011 9:16 AM
To: ozDotNet
Subject: Re: categorizing ms test tests

 

Yes, install Resharper, then open the Unit test windows (Ctrl-Alt-U) and
you can group by lots of things:

 
On 22/11/2011 6:55 AM, Liam McLennan wrote: 

Howdy, 

 

Does anyone know a way to group ms test tests into categories at the
class level? I don't want to have to add [TestCategory] attributes to
every method.

 

Thanks,

Liam.

 

image001.pngimage002.png

RE: categorizing ms test tests

2011-11-21 Thread Clint Colefax
Actually, I retracted that, seems you can't group by Categories
specifically, but most other things you can (I always group by test
project or test class)

 

Thanks

Clint Colefax

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Clint Colefax
Sent: Tuesday, 22 November 2011 9:27 AM
To: ozDotNet
Subject: RE: categorizing ms test tests

 

If this is all you're after, you don't need resharper to do this, vs's
interfaces do exactly the same thing.

 

 

 

Thanks

Clint Colefax

 

From: ozdotnet-boun...@ozdotnet.com [
mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Wallace Turner
Sent: Tuesday, 22 November 2011 9:16 AM
To: ozDotNet
Subject: Re: categorizing ms test tests

 

Yes, install Resharper, then open the Unit test windows (Ctrl-Alt-U) and
you can group by lots of things:

 
On 22/11/2011 6:55 AM, Liam McLennan wrote: 

Howdy, 

 

Does anyone know a way to group ms test tests into categories at the
class level? I don't want to have to add [TestCategory] attributes to
every method.

 

Thanks,

Liam.

 

image001.pngimage002.png

RE: Latest MS Sync Framework?

2011-09-11 Thread Clint Colefax
Team blog seems to still active, might find more info there?

 

http://blogs.msdn.com/b/sync/

 

Thanks

Clint Colefax

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Preet Sangha
Sent: Monday, 12 September 2011 1:38 PM
To: ozDotNet
Subject: Latest MS Sync Framework?

 

Looking at the sync framework home page
(http://msdn.microsoft.com/en-us/sync/bb736753) I see that CTP 4.0 (from
October 2010) is listed. Is this really the last update - that seems
pretty ancient? Or is there codeplex type releases that I should be
looking at instead. It look like an interesting technology for off line
phone applications.

 

Also thinking about it, does anyone on the list use it or a competing
technology? 

 

-- 
regards,
Preet, Overlooking the Ocean, Auckland



RE: ASP.NET Dynamic Data

2011-08-16 Thread Clint Colefax
Hi All,

 

A friend of mine is asking me questions about ASP.NET Dynamic Data

 

http://www.asp.net/dynamicdata

 

With me not being in the web UI space much, I'd never heard of it
before. Any opinions on it's worth? He's building a large enterprise
system, that is to replace his companies legacy system (they are about
to go through a massive growth spurt, and have recognized their current
system, which they inherited in a buy out situation, is just not going
to cut it). I'm trying to convince him to architect the system properly
with a nice layed approach, but this Dynamic Data seems to want to
reference the entity framework context directly, which to my
understanding will make it impossible to put a service layer in place,
so use concepts like repository implementations, etc, etc.

 

To be it sounds like something he should pass over, but it's shiny and
new to him, which  has taken his attention, even tho all he seems to be
able to tell me is how it won't work.

 

Should he persist with this, or is there a better direction he should
take now.

 

Any advice greatly appreciated.

Thanks

 

 

 

 

image001.jpg

RE: Entity Framework and Linq

2011-04-19 Thread Clint Colefax
Thanks James,

 

That's pretty much what I ended up with, although I'm using EF, so
navigating the joins via EF navigation properties, rather then do a linq
join.

 

No worries about it being c#, I'm actually starting to prefer c# I
think..

 

Thanks

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of James Chapman-Smith
Sent: Tuesday, 19 April 2011 12:25 PM
To: 'ozDotNet'
Subject: RE: Entity Framework and Linq

 

Hi Clint,

 

Is this what you're after?

 

   var q =

  from c1 in context.Customers

  where c1.Name == Fred

  join c2 in context.Countries on c1.Country equals c2

  join c3 in context.CountryRegions on c2 equals c3.Country

  where c3.RegionLanguage == English

  orderby c1.CreatedDate 

  select new

  {

 Customer = c1,

 Country = c2,

 Region = c3,

  };

 

My apologies for it being c#.

 

It assumes that your model looks like this:

 

public class Context

{

   public ListCustomer Customers = new ListCustomer();

   public ListCountry Countries = new ListCountry();

   public ListRegion CountryRegions = new ListRegion();

}

 

public class Country

{

   public ListCustomer Customers = new ListCustomer();

   public ListRegion CountryRegions = new ListRegion();

}

 

public class Customer

{

   public string Name;

   public Country Country;

   public DateTime CreatedDate;

}

 

public class Region

{

   public Country Country;

   public string RegionLanguage;

}

 

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Clint Colefax
Sent: Monday, 18 April 2011 10:42
To: ozDotNet
Subject: Entity Framework and Linq

 

I have 3 tables with a many to one to many relationship. 

 

Customers = Countries = CountryRegions

 

I want the first Customer where name = Fred and the CountryRegions
where Language = English. I want to include the Country and Country
Region entities

 

Sql would be something like this.

 

Select top 1 *

From Customers as c1

Inner join Countries as c2

On c1.CountryNo = c2.CountryNo

Inner join CountryRegions as c3

On c2.CountryNo = c3.CountryNo

And c3.RegionLanguage = English

Where c1.name = Fred

Order c1.CreatedDate

 

I am trying to replicate this in Entity Framework with Linq, and I just
can't seem to get there at all. Any pointer would be helpful. I'm able
to either include all the sub elements, or condition on them, but can't
seem to do both. I know I could do a load statement, but I'm trying to
avoid that.

 

One of my attempts

 

Dim q = from c2 in context.Countries

From c1 in c2.customers

Where c2.Name = Fred

From c3 in c2.CountryRegions

Where c3.RegionLanguage = English

Order by c1.CreatedDate 

Select c1 Take 1

 

This gives me the correct customer, but without the country and country
region. I tried adding .Include() on the end of context.Countries
without luck. But by taking the result of this (q) and running
q.include(Country) I could get the country included, but I also need
the CountryRegion, and that's on the other side of the one to many to
one relationship.

 

Any ideas?

 

Thanks

 

p.s. This is in entity framework 3.5 if that makes any difference.

 

 

image001.jpg

Entity Framework and Linq

2011-04-17 Thread Clint Colefax
I have 3 tables with a many to one to many relationship. 

 

Customers = Countries = CountryRegions

 

I want the first Customer where name = Fred and the CountryRegions
where Language = English. I want to include the Country and Country
Region entities

 

Sql would be something like this.

 

Select top 1 *

From Customers as c1

Inner join Countries as c2

On c1.CountryNo = c2.CountryNo

Inner join CountryRegions as c3

On c2.CountryNo = c3.CountryNo

And c3.RegionLanguage = English

Where c1.name = Fred

Order c1.CreatedDate

 

I am trying to replicate this in Entity Framework with Linq, and I just
can't seem to get there at all. Any pointer would be helpful. I'm able
to either include all the sub elements, or condition on them, but can't
seem to do both. I know I could do a load statement, but I'm trying to
avoid that.

 

One of my attempts

 

Dim q = from c2 in context.Countries

From c1 in c2.customers

Where c2.Name = Fred

From c3 in c2.CountryRegions

Where c3.RegionLanguage = English

Order by c1.CreatedDate 

Select c1 Take 1

 

This gives me the correct customer, but without the country and country
region. I tried adding .Include() on the end of context.Countries
without luck. But by taking the result of this (q) and running
q.include(Country) I could get the country included, but I also need
the CountryRegion, and that's on the other side of the one to many to
one relationship.

 

Any ideas?

 

Thanks

 

p.s. This is in entity framework 3.5 if that makes any difference.

 

 

image001.jpg

RE: Entity Framework and Linq

2011-04-17 Thread Clint Colefax
Thanks Dude, I will have a look at this, I was trying to avoid this as I
will have to return 3 classes in a anon type, then reconstruct them via
navigation properties.

 

Thanks 

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of DotNet Dude
Sent: Monday, 18 April 2011 11:18 AM
To: ozDotNet
Subject: Re: Entity Framework and Linq

 

 

On Mon, Apr 18, 2011 at 11:12 AM, Clint Colefax
clint.cole...@dataaspects.com.au wrote:

I have 3 tables with a many to one to many relationship. 

 

Customers = Countries = CountryRegions

 

I want the first Customer where name = Fred and the CountryRegions
where Language = English. I want to include the Country and Country
Region entities

 

Sql would be something like this.

 

Select top 1 *

From Customers as c1

Inner join Countries as c2

On c1.CountryNo = c2.CountryNo

Inner join CountryRegions as c3

On c2.CountryNo = c3.CountryNo

And c3.RegionLanguage = English

Where c1.name = Fred

Order c1.CreatedDate

 

I am trying to replicate this in Entity Framework with Linq, and I just
can't seem to get there at all. Any pointer would be helpful. I'm able
to either include all the sub elements, or condition on them, but can't
seem to do both. I know I could do a load statement, but I'm trying to
avoid that.

 

One of my attempts

 

Dim q = from c2 in context.Countries

From c1 in c2.customers

Where c2.Name = Fred

From c3 in c2.CountryRegions

Where c3.RegionLanguage = English

Order by c1.CreatedDate 

Select c1 Take 1

 

only had a quick look but you're only selecting the customer, if you
want the country and region then you'd need to select them too in the
last line

 

 

This gives me the correct customer, but without the country and
country region. I tried adding .Include() on the end of
context.Countries without luck. But by taking the result of this (q) and
running q.include(Country) I could get the country included, but I
also need the CountryRegion, and that's on the other side of the one to
many to one relationship.

 

Any ideas?

 

Thanks

 

p.s. This is in entity framework 3.5 if that makes any
difference.

Clint_C

 

 



RE: Entity Framework and Linq

2011-04-17 Thread Clint Colefax
Neil and DotNet Dude,

Thanks for your help on this one, I end up returning all 3 items, and it
then maintained the navigation property automatically... strange, but
great.

So end result is..

Dim q = from c2 in context.Countries
From c1 in c2.customers
Where c2.Name = Fred
From c3 in c2.CountryRegions
Where c3.RegionLanguage = English
Order by c1.CreatedDate
Select c1, c2, c3 Take 1

return q.First.c2

-Original Message-
From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Neil Young
Sent: Monday, 18 April 2011 1:04 PM
To: ozDotNet
Subject: Re: Entity Framework and Linq

Clint, ok didn't click on the bit about needing to retain the filter
on the third level down.  I don't think there's a way to do that with
include statements, as by their very nature they are just meant to
include the related objects to save a database call, it would the
navigation properties a little exciting if you didn't know whether
they were a filtered set or not.  I don't think you are going to have
much of a choice but to go out to a new specific type for this.

On 18 April 2011 12:47, Clint Colefax clint.cole...@dataaspects.com.au
wrote:
 I like the look of those strategies, however it's probably to late to
 implement that in this current version of our project. Using you 2nd
option
 does not filter the OrderLines. In my case, I get the right
Customer, and
 Countries, then every CountryRegion for that country. It doesn't
maintain
 the filter.

 I think I'll be looking at the 3rd option, into a non type, then
 reconstructing the Customer class by added the other items to it via
 navigation properties. This was something I was trying to avoid, but
my
 options are shrinking.



 Thanks for you help.



 From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com]
 On Behalf Of Neil Young
 Sent: Monday, 18 April 2011 12:10 PM

 To: ozDotNet
 Subject: Re: Entity Framework and Linq



 Clint,



 Have three suggestions.



 1. We are using EF in a repositry pattern and each repositry has it's
own
 include strategy using the code here (nicely strongly type):


http://blogs.msdn.com/b/alexj/archive/2009/07/25/tip-28-how-to-implement
-include-strategies.aspx,
 this works really well and the blog post does say that it works in 3.5
(we
 are in 4).  Regardless of the repositry pattern you can still use
this.



 2. The help seems to indicate that you just call
 Include(Orders.OrderLines), and in that case it will include orders
and
 orderlines (haven't used include in a long time so can't comment on
the
 veracity of this)



 3.  You can always create an anonymous type and (or non anonymous) and
 return the things you want explicitly in the select as DotNet Dude was
 suggesting.



 Neil.

 On 18 April 2011 11:18, DotNet Dude adotnetd...@gmail.com wrote:



 On Mon, Apr 18, 2011 at 11:12 AM, Clint Colefax
 clint.cole...@dataaspects.com.au wrote:

 I have 3 tables with a many to one to many relationship.



 Customers = Countries = CountryRegions



 I want the first Customer where name = Fred and the CountryRegions
where
 Language = English. I want to include the Country and Country Region
 entities



 Sql would be something like this.



 Select top 1 *

 From Customers as c1

 Inner join Countries as c2

 On c1.CountryNo = c2.CountryNo

 Inner join CountryRegions as c3

 On c2.CountryNo = c3.CountryNo

 And c3.RegionLanguage = English

 Where c1.name = Fred

 Order c1.CreatedDate



 I am trying to replicate this in Entity Framework with Linq, and I
just
 can't seem to get there at all. Any pointer would be helpful. I'm able
to
 either include all the sub elements, or condition on them, but can't
seem to
 do both. I know I could do a load statement, but I'm trying to avoid
that.



 One of my attempts



 Dim q = from c2 in context.Countries

 From c1 in c2.customers

 Where c2.Name = Fred

 From c3 in c2.CountryRegions

 Where c3.RegionLanguage = English

 Order by c1.CreatedDate

 Select c1 Take 1



 only had a quick look but you're only selecting the customer, if you
want
 the country and region then you'd need to select them too in the last
line





 This gives me the correct customer, but without the country and
country
 region. I tried adding .Include() on the end of context.Countries
without
 luck. But by taking the result of this (q) and running
q.include(Country)
 I could get the country included, but I also need the CountryRegion,
and
 that's on the other side of the one to many to one relationship.



 Any ideas?



 Thanks



 p.s. This is in entity framework 3.5 if that makes any difference.

 Error! Filename not specified.









RE: Looking for 19inch server rack

2011-02-02 Thread Clint Colefax
Check with computer recyclers. I checked with a mate of mine that runs
one on the gold coast, and unfortunately, he scrapped 3 last week as the
didn't have any sides. They're not expecting any more anytime soon on
the gold coast.

-Original Message-
From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of David Boccabella
Sent: Thursday, 3 February 2011 9:52 AM
To: 'ozDotNet'
Subject: Looking for 19inch server rack

Hi Folks

I'm on the scavenge. I am looking for an old server rack poss 42RU + and
at
least 900mm deep. Condition does not have to be perfect either.
Essentially
I have 4 standard non-rack servers and I need to be able to shelve them.
I
will be moving to rackable equip in time.
Not worried about covers, doors etc though they would be a bonus.

I'm happy to pay something for it, and the transport costs. I am in
Brisbane
so please no interstate offers. I have looked on eBay also and likewise
anything interesting is interstate.

My office is being moved and I am on a tight budget to fit everything in
(Myself, Desk, and 4 servers)

Many thanks
Dave



David J. Boccabella
Proprietor
Anubis Systems
Phone: 0433 808 525
Fax: 3200 0085
Email:  davidboccabe...@anubis-systems.com

This e-mail and it's contents is confidential to Anubis Systems.
This e-mail, any attachments, or any part of can not be reproduced
without the express written permission of Anubis Systems







Specification pattern, linq and ef

2011-01-03 Thread Clint Colefax
Has anyone done much with the specification pattern? I've start playing
around with it a bit, and I've hit a limitation pretty early on. 

 

For example, I'm trying to get a list of entity, by another value on
another entity, which does not have a direct link(navigation point).

 

The linq query on the context is something like this (without using
specification pattern)

 

Dim q = From c In _context.Coupons _
Join l In _context.Products _
On c.Product.ProductNo Equals l.ProductNo _
Join r In _context.Prices _
On l.ProductNo Equals r.Products.ProductNo _
Where c.couponNo = couponNo _ 'Param value here 
And r.StartDate = c.OfferDate _
And (r.EndDate Is Nothing OrElse r.EndDate = c.OfferDate) _
Select r

 

This is attempting to get all the prices whose Start and EndDate
encapsulate the coupons offer date.

 

Because I don't have a context with the specification pattern, I need to
do it all from the perspective of the Price (this is a Price
specification, get prices by coupon), but I can't navigate from the
price to the product or coupons. I almost need the specification to be
in the perspective of the context (a level up), but I'm not sure.

 

Anyone come across this trying to implement this pattern? Any work
arounds\ideas?

 

Thanks

 

 

 

 

image002.jpg

RE: Tertiary education

2010-11-23 Thread Clint Colefax
Hi Dylan,

 

It Masters offers .net tertiary course, but they are by correspondence
only I think.

 

www.itmasters.com.au

 

Thanks

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Dylan Tusler
Sent: Wednesday, 24 November 2010 1:48 PM
To: 'ozDotNet'
Subject: Tertiary education

 

__   
Sunshine Coast Regional Council http://www.sunshinecoast.qld.gov.au/ 

We've got a staff member who wants to enrol in some tertiary IT courses,
and I'm looking for recommendations for courses that will give exposure
to C# and SQL Server.

 

I've been looking at the external offerings from USQ
(http://www.usq.edu.au/handbook/2010/bus/BITC.html), which mentions
.net, but I think they focus on C++ for OO development, and use Java and
Oracle predominantly.

 

USC (our local uni) seems to specialise in Java too.

 

Does anyone have any idea whether there are any offerings (pref external
part time) that might suit?

 

I'm slowly working my way through various places, starting in SE Qld.

 

Dylan Tusler
Acting Data, Development  Integration Manager
ICTS Branch
Sunshine Coast Council
ph: +61 (0)7 5420 8002 mon, tue, wed
ph: +61 (0)7 5441 8202 thu, fri

 



To find out more about the Sunshine Coast Regional Council, visit your
local office at Caloundra, Maroochydore, Nambour or Tewantin or visit us
online at www.sunshinecoast.qld.gov.au
http://www.sunshinecoast.qld.gov.au/ .  If correspondence includes
personal information, please refer to Council's Privacy Policy
http://www.sunshinecoast.qld.gov.au/sitePage.cfm?code=disclaimer .

This email and any attachments are confidential and only for the use of
the addressee.  If you have received this email in error you are
requested to notify the sender by return email or contact council on
1300 00 7272 and are prohibited from forwarding, printing, copying or
using it in anyway, in whole or part. Please note that some council
staff utilise Blackberry devices, which results in information being
transmitted overseas prior to delivery of any communication to the
device. In sending an email to Council you are agreeing that the content
of your email may be transmitted overseas.
Any views expressed in this email are the author's, except where the
email makes it clear otherwise. The unauthorised publication of an email
and any attachments generated for the official functions of council is
strictly prohibited. Please note that council is subject to the Right to
Information Act 2009 (Qld) and Information Privacy Act 2009 (Qld).



RE: Tertiary education

2010-11-23 Thread Clint Colefax
http://www.itmasters.edu.au/WhichQualification/GraduateCertificates/Grad
CertinSystemsDevelopment/MicrosoftNet35.aspx

 

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Dylan Tusler
Sent: Wednesday, 24 November 2010 2:50 PM
To: 'ozDotNet'
Subject: RE: Tertiary education

 

Looks interesting, but it seems to have a bent towards postgrad study.
Our staffer is undergrad, and I just had a look at CSU's undergrad
offerings and they are all Java or C++.

 

I doubt he has sufficient work experience to qualify for a masters, but
I will take a closer look.

 

Dylan.

 

 

 

 

 

 



From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Maddin, Peter
Sent: Wednesday, 24 November 2010 2:31 PM
To: ozDotNet
Subject: RE: Tertiary education

I did the Masters in Systems Development (Charles Sturt Uni), as an
external student (Distance Education).

Half the courseware is Microsoft based and the other half are Uni units
(12 units in all).

 

The Microsoft units are the standard Microsoft training courses. Those
that come with standard training book/kit and they had some online
(Webex) sessions in lieu of on-campus lectures. You can choose C# or
VB.Net. The exams are the same as for when you do std Microsoft training
except the vouchers for the exams indentified them as Uni Based.

One of the electives I did was for SQL Server 2005 (that was current at
the time).

 

The curriculum has been updated since I did mine, which was .Net 2.0
based.

 

Regards Peter Maddin
Applications Development Officer
PathWest Laboratory Medicine WA
Phone : +618 9473 3944
Fax : +618 9473 3982
E-Mail : peter.mad...@pathwest.wa.gov.au
The contents of this e-mail transmission outside of the WAGHS network
are intended solely for the named recipient's), may be confidential, and
may be privileged or otherwise protected from disclosure in the public
interest. The use, reproduction, disclosure or distribution of the
contents of this e-mail transmission by any person other than the named
recipient(s) is prohibited. If you are not a named recipient please
notify the sender immediately.

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Dylan Tusler
Sent: Wednesday, 24 November 2010 11:48 AM
To: 'ozDotNet'
Subject: Tertiary education

 

__   
Sunshine Coast Regional Council http://www.sunshinecoast.qld.gov.au/ 

We've got a staff member who wants to enrol in some tertiary IT courses,
and I'm looking for recommendations for courses that will give exposure
to C# and SQL Server.

 

I've been looking at the external offerings from USQ
(http://www.usq.edu.au/handbook/2010/bus/BITC.html), which mentions
.net, but I think they focus on C++ for OO development, and use Java and
Oracle predominantly.

 

USC (our local uni) seems to specialise in Java too.

 

Does anyone have any idea whether there are any offerings (pref external
part time) that might suit?

 

I'm slowly working my way through various places, starting in SE Qld.

 

Dylan Tusler
Acting Data, Development  Integration Manager
ICTS Branch
Sunshine Coast Council
ph: +61 (0)7 5420 8002 mon, tue, wed
ph: +61 (0)7 5441 8202 thu, fri

 



To find out more about the Sunshine Coast Regional Council, visit your
local office at Caloundra, Maroochydore, Nambour or Tewantin or visit us
online at www.sunshinecoast.qld.gov.au
http://www.sunshinecoast.qld.gov.au/ .  If correspondence includes
personal information, please refer to Council's Privacy Policy
http://www.sunshinecoast.qld.gov.au/sitePage.cfm?code=disclaimer .

This email and any attachments are confidential and only for the use of
the addressee.  If you have received this email in error you are
requested to notify the sender by return email or contact council on
1300 00 7272 and are prohibited from forwarding, printing, copying or
using it in anyway, in whole or part. Please note that some council
staff utilise Blackberry devices, which results in information being
transmitted overseas prior to delivery of any communication to the
device. In sending an email to Council you are agreeing that the content
of your email may be transmitted overseas.
Any views expressed in this email are the author's, except where the
email makes it clear otherwise. The unauthorised publication of an email
and any attachments generated for the official functions of council is
strictly prohibited. Please note that council is subject to the Right to
Information Act 2009 (Qld) and Information Privacy Act 2009 (Qld).



RE: It's a question of Generics...

2010-11-04 Thread Clint Colefax
Thanks James,

 

In the end, I just added the extra generic parameters and continued,
it's not a pretty as I had hoped, but it does work.

 

In the end, my question boiled down to, it I create an interface that
has generic parameters 

 

Interface IMyInterface(of T)

 

 which I then write an implementing class such as

 

Class MyClass implements IMyInterface(of SomeObject)

 

Where I've defined the type of that generic parameter,

 

Then I want a function to return any implementation of the interface

 

Function MyFunction() As IMyInterface(of T)

 

I can't, as like you said, I've not defined the generic parameter

 

If I change this to 

Function MyFunction(Of T)() As IMyInterface(Of T)

 

Then it will work. However, I wanted to be able to set the T to an
implementation of the interface, which has T defined in it, and have it
work it out, like

 

Function MyFunction(Of P As  IMyInterface(Of T))() As IMyInterface(Of T)

 

I could then call it like

 

MyFunction(Of MyClass)() 

 

and it would return an instance of MyClass.

 

Anyway, this was an exploratory exercise, and I'm kind of moving away
from this. One thought I did have was to have 2 interfaces, a non
generic one that defined nothing, and the generic one that inherited
from it

 

Interface IMyInterface

 

Interface IMyGenericInterface (Of T)

Inherits IMyInterface

 

Then my function could return any instance of the non generic interface,
but I've not tried this as I've moved on.

 

Thanks for the feedback.

 

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of James Chapman-Smith
Sent: Thursday, 4 November 2010 4:36 PM
To: 'ozDotNet'
Subject: RE: It's a question of Generics...

 

Hi Clint,

 

What you're suggesting here can't work. Type inference only works when
passing a parameter to a function (not a generic parameter). If you want
to return an object of type `IBase(Of T, E)` then the function
definition must include the `T`  `E` types. Your function only has a
single generic parameter so it won't work.

 

Can you post a version of your original code? Or maybe more detail of
your intent? If you can, I might be able to suggest what to do.

 

Cheers.

 

James.

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Clint Colefax
Sent: Thursday, 4 November 2010 09:55
To: ozdotnet@ozdotnet.com
Subject: It's a question of Generics...

 

Just playing around with some generics, and I'm getting one bit that I'm
not happy with. I thought I had this working, but I've changed something
and now it doesn't. 

 

 

I have an interface 

Interface IBase(Of T, E)

 

And a child interface

Interface ILevel1

 

And a Class

Class Level1

Implements ILevel1

Implements IBase(of string, integer)

 

Then I have a factory with a method as such

 

 

Function GetALevel(Of TLevel(Of T, E)() As IBase(Of T, E)

 

In another class, I want to call the following

 

Dim foo as Factory = new Factory

Dim bar as foo.GetALevel(Of ILevel1)()

 

I think that the type of T and E should be inferred from the ILevel
interface. I'm sure I had this working, then a made a number of changes
all around this code, then noticed it wasn't working anymore.

 

Can anyone explain this better?


Thanks

Clint Colefax



It's a question of Generics...

2010-11-03 Thread Clint Colefax
Just playing around with some generics, and I'm getting one bit that I'm
not happy with. I thought I had this working, but I've changed something
and now it doesn't. 

 

 

I have an interface 

Interface IBase(Of T, E)

 

And a child interface

Interface ILevel1

 

And a Class

Class Level1

Implements ILevel1

Implements IBase(of string, integer)

 

Then I have a factory with a method as such

 

 

Function GetALevel(Of TLevel(Of T, E)() As IBase(Of T, E)

 

In another class, I want to call the following

 

Dim foo as Factory = new Factory

Dim bar as foo.GetALevel(Of ILevel1)()

 

I think that the type of T and E should be inferred from the ILevel
interface. I'm sure I had this working, then a made a number of changes
all around this code, then noticed it wasn't working anymore.

 

Can anyone explain this better?


Thanks

Clint Colefax



Starting out with Entity Framework

2010-05-30 Thread Clint Colefax
Hi all,

 

I'm starting out with Entity Framework (.NET 3.5) and am curious if it
can handle the following scenario and how to go about implementing it.

 

Say I have single table like so

 

TableName:   Languages

Columns: Name

TranslatedMonths

 

An example row would be

Name=English

TranslatedMonths =Jan, Feb, Mar

 

In the entities layer, I want this represented as to types of classes, 

 

ClassName:Languages

Memebers:Name

List(Of Months)

 

Can I do this with EF? Where do I start. I've played a bit with this
scenario but can't seem to get it to where I want. I've done a bit with
Partial Classes for this so far, but I'm just not happy with trying to
keep the String property created by ef in sync with my custom added list
property. For this I'd like to remove the property from the entity in
the designer, but not sure how then to have that database value loaded
so I can parse it out into my list.

 

Thanks

 

 

image002.jpg

RE: Starting out with Entity Framework

2010-05-30 Thread Clint Colefax
Thanks Mitch,

 

Currently, change the database structure is not an option. Seems like it
would, but this example is showing what needs to be accomplished, but
it's not actually languages and translations.

 

Thanks

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Mitch Wheat
Sent: Monday, 31 May 2010 12:49 PM
To: 'ozDotNet'
Subject: RE: Starting out with Entity Framework

 

That's not in 1st Normal form.

 

One possibility: If you have a known, finite list of languages to
support add extra columns to the Month table for each language.

 

or create a general lookup table that contains 3 columns, englishword,
languageID, translatedword.

 

My 2 cents.

 

Mitch

 

From: ozdotnet-boun...@ozdotnet.com
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Clint Colefax
Sent: Monday, 31 May 2010 10:30 AM
To: ozdotnet@ozdotnet.com
Subject: Starting out with Entity Framework

 

Hi all,

 

I'm starting out with Entity Framework (.NET 3.5) and am curious if it
can handle the following scenario and how to go about implementing it.

 

Say I have single table like so

 

TableName:   Languages

Columns: Name

TranslatedMonths

 

An example row would be

Name=English

TranslatedMonths =Jan, Feb, Mar

 

In the entities layer, I want this represented as to types of classes, 

 

ClassName:Languages

Memebers:Name

List(Of Months)

 

Can I do this with EF? Where do I start. I've played a bit with this
scenario but can't seem to get it to where I want. I've done a bit with
Partial Classes for this so far, but I'm just not happy with trying to
keep the String property created by ef in sync with my custom added list
property. For this I'd like to remove the property from the entity in
the designer, but not sure how then to have that database value loaded
so I can parse it out into my list.

 

Thanks

 

 

image001.jpg