title: Split a string in a linq select expression
body: <p>The geoStartLoc holds the string in this format "54.5,44.5". I am trying to split and store the results  in lat and longitude. I am getting the following error
  <strong>LINQ to Entities does not recognize the method 'System.String[] Split(Char[])' method, and this method cannot be translated into a store expression. (select statement)</strong> </p>
  
  <pre><code>var data = from UberTrip in db.UberTrips
             group UberTrip by new { UberTrip.startLoc, UberTrip.geoStartLoc } 
             into startLocGroup
             select new LocationGroup() {
                 startLocation = startLocGroup.Key.startLoc,
                 latitude = startLocGroup.Key.geoStartLoc.Split(',').Count().ToString(),
                 //longitude= startLocGroup.Key.
                 countTrips = startLocGroup.Count()
             };
  </code></pre>