Not signed in (Sign In)
  • CommentAuthorpjacobs
  • CommentTimeApr 11th 2009
 
is there a way in the designer to combine the database fields FirstName and LastName into FullName for my mapping or class?

Thanks.
  • CommentAuthorSupport
  • CommentTimeApr 11th 2009
 
You could concatenate the two strings and combine them into one column in your SQL.

Eg: Select (Person.Contact.FirstName + ' ' + Person.Contact.LastName) As FullName

Your generated object would then have a FullName property mapped to it.
  • CommentAuthorpjacobs
  • CommentTimeApr 11th 2009
 
yeah, i did that but my question was "Could it be done in the designer?" so I guess it can't. No problem! thanks
  • CommentAuthorSupport
  • CommentTimeApr 11th 2009
 
Yes, the designer is helpful for a lot of other things, specially creating joins, aggregations, group bys, sorting, nested queries, unions. It does not handle calling functions, concatenations and formatting. That has to be done manually in the SQL.
  • CommentAuthorsosports
  • CommentTimeJul 28th 2010
 
we offer cheap and high quality Vibram FiveFingers.They are <a href="http://www.so-sports.com/vibram-fivefingers-kso-c-1.html?zenid=70470f567c30cc38adddbc4cb57c4854" class="STYLE1">all new.</a>.People are finally beginning to come around to that inconvenient truth about our feet, that dirty little secret that shoe companies would prefer to keep under wraps: barefoot is better.When you wear <a href="http://www.so-sports.com/vibram-fivefingers-kso-c-1.html?zenid=70470f567c30cc38adddbc4cb57c4854" class="STYLE1">Vibram shoes</a>,you will feel you are barefoot. </p>
<p>There has been media coverage of the barefoot trend in the past, mostly intermittent, in running magazines and always taking a patronizing tone.<strong><a href="http://www.so-sports.com/vibram-fivefingers-sprint-c-2.html" class="STYLE2">Vibram FiveFingers Sprint</a></strong> follows the same formula: more idle speculation on a bizarre fad that a select few crazies are promoting, with plenty of “balance” from stuffy foot specialists expressing doubt that the inherently fragile, gentle human foot could ever withstand the rigors of walking unshod without “serious injury,” than any serious consideration of the merits. But now we’ve got a nice,<a href="http://www.so-sports.com/vibram-fivefingers-kso-c-1.html?zenid=70470f567c30cc38adddbc4cb57c4854" class="STYLE1">cheap Vibram</a> juicy study to hang our hats (or our shoes) on, and media outlets are falling over themselves to get the scoop.</p>
<p>Write by: <a href="http://www.so-sports.com/vibram-fivefingers-kso-c-1.html?zenid=70470f567c30cc38adddbc4cb57c4854" class="STYLE1">Vibram FiveFingers
  • CommentAuthorsosports
  • CommentTimeJul 28th 2010
 
we offer cheap and high quality Vibram FiveFingers.

http://www.so-sports.com
Nike Shox R4
Nike Air Jordan
Nike Air Max 90
Nike Air Structure Triax 91
Nike Air Max 95
Nike Air Max 2003 Mens
Nike Air Max 2009
Nike Air Classic BW
Vibram FiveFingers KSO
Vibram FiveFingers SPRINT
Vibram FiveFingers SPRINT Women
Vibram FiveFingers CLASSIC
Vibram FiveFingers FLOW Men
Vibram FiveFingers 2010 New
http://www.so-sports.com
  • CommentAuthorsosports
  • CommentTimeJul 28th 2010
 
http://www.p90xkicks.com/

we offer cheap and high quality p90x workout dvd
about p90x
p90x
how does p90x work?
Insanity Workout
BeachBody
chaLAN Extreme
Brazil Butt lift Workouts
Rev Abs Workout
Core Rhythms 4 DVD Dance Exercis
Pump it up 5 DVD
ZUMBA workout 4 DVD
Cartoon DVD
Education series
DVD movie and TV serial
Such a trend welcome to buy thank you!
http://www.p90xkicks.com/