/// <summary>
/// Create a new WebCustomer object.
/// </summary>
/// <param name="customerId">Initial value of the CustomerId property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="zip">Initial value of the Zip property.</param>
public static WebCustomer CreateWebCustomer(global::System.Int32 customerId, global::System.String name, global::System.String zip)
{
WebCustomer webCustomer = new WebCustomer();
webCustomer.CustomerId = customerId;
webCustomer.Name = name;
webCustomer.Zip = zip;
return(webCustomer);
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var c1 = new WebCustomer {
Name = "Alex Stevens", Zip = "76039"
};
var c2 = new WebCustomer {
Name = "Janis Jones", Zip = "76040"
};
var c3 = new WebCustomer {
Name = "Cathy Robins", Zip = "76111"
};
context.Zips.AddObject(new Zip {
Latitude = 32.834298M, Longitude = -32.834298M, ZipCode = "76039"
});
context.Zips.AddObject(new Zip {
Latitude = 32.835298M, Longitude = -32.834798M, ZipCode = "76040"
});
context.Zips.AddObject(new Zip {
Latitude = 33.834298M, Longitude = -31.834298M, ZipCode = "76111"
});
context.WebCustomers.AddObject(c1);
context.WebCustomers.AddObject(c2);
context.WebCustomers.AddObject(c3);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
string esql = @"select value c
from EFRecipesEntities.WebCustomers as c
join
(SELECT z.ZipCode,
3958.75 * (SqlServer.Atan(SqlServer.Sqrt(1 -
SqlServer.power(((SqlServer.Sin(t2.Latitude/57.2958M) *
SqlServer.Sin(z.Latitude/57.2958M)) +
(SqlServer.Cos(t2.Latitude/57.2958M) * SqlServer.Cos(z.Latitude/57.2958M) *
SqlServer.Cos((z.Longitude/57.2958M) -(t2.Longitude/57.2958M)))), 2)) /(
((SqlServer.Sin(t2.Latitude/57.2958M) * SqlServer.Sin(z.Latitude/57.2958M)) +
(SqlServer.Cos(t2.Latitude/57.2958M) * SqlServer.Cos(z.Latitude/57.2958M) *
SqlServer.Cos((z.Longitude/57.2958M) - (t2.Longitude/57.2958M))))))
) as DistanceInMiles
FROM EFRecipesEntities.Zips AS z join
(select top(1) z2.Latitude as Latitude,z2.Longitude as Longitude
from EFRecipesEntities.Zips as z2
where z2.ZipCode = @Zip
) as t2 on 1 = 1
) as matchingzips on matchingzips.ZipCode = c.Zip
where matchingzips.DistanceInMiles <= @RadiusInMiles";
var custs = context.CreateQuery <WebCustomer>(esql, new ObjectParameter("Zip", "76039"), new ObjectParameter("RadiusInMiles", 5));
Console.WriteLine("Customers within 5 miles of 76039");
foreach (var cust in custs)
{
Console.WriteLine("Customer: {0}", cust.Name);
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
/// <summary>
/// Deprecated Method for adding a new object to the WebCustomers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToWebCustomers(WebCustomer webCustomer)
{
base.AddObject("WebCustomers", webCustomer);
}