void generateEntities() //use connection param to modify the connection string and dbcontext;
{ //to continue
string ip = this.ServerIp;
string username = this.ServerUsername;
string password = this.ServerPassword;
//Data Source=192.168.28.129;Initial Catalog=Dblibrary;Persist Security Info=True;User ID=sa;Password=19831122
String sqlConnectionString = "Data Source=" + ServerIp + ";Initial Catalog=Location;Persist Security Info=True;User ID=" + ServerUsername + ";Password="******"res://*/Models.Location.csdl|res://*/Models.Location.ssdl|res://*/Models.Location.msl";
eb.Provider = "System.Data.SqlClient";
eb.ProviderConnectionString = sqlConnectionString;
this.entitiesConnectionString = eb.ToString();
this.dbEntities = new LocationEntities(this.entitiesConnectionString);
}
public static void InsertLocation()
{
using (var context = new LocationEntities())
{
var park = new Park
{
Name = "11th Street Park",
Address = "801 11th Street",
City = "Aledo",
State = "TX",
ZIPCode = "76106"
};
var loc = new Location
{
Address = "501 Main",
City = "Weatherford",
State = "TX",
ZIPCode = "76201"
};
park.Office = loc;
context.Locations.Add(park);
context.SaveChanges();
}
}
public bool UpdateLocation(int LocationId, LocationEntities LocationEntities)
{
throw new NotImplementedException();
}
public int CreateLocation(LocationEntities LocationEntities)
{
throw new NotImplementedException();
}
