static int Main(string[] args)
{
try
{
Console.WriteLine($"Profiler attached: {Instrumentation.ProfilerAttached}");
using (var ctx = new SchoolDbContextEntities())
{
// create database if missing
ctx.Database.CreateIfNotExists();
var student = new Student()
{
StudentName = "Bill", Age = 12
};
ctx.Students.Add(student);
ctx.SaveChanges();
}
// Specify the provider name, server and database.
string providerName = "System.Data.SqlClient";
string serverName = @"(localdb)\MSSQLLocalDB";
string databaseName = "SchoolDbContext";
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder();
// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.IntegratedSecurity = true;
// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
new EntityConnectionStringBuilder();
//Set the provider name.
entityBuilder.Provider = providerName;
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = providerString;
// Set the Metadata location.
entityBuilder.Metadata = @"res://*/SchoolModel.csdl|
res://*/SchoolModel.ssdl|
res://*/SchoolModel.msl";
Console.WriteLine(entityBuilder.ToString());
using (EntityConnection conn =
new EntityConnection(entityBuilder.ToString()))
{
conn.Open();
using (EntityCommand cmd = conn.CreateCommand())
{
Console.WriteLine("Creating an EntityCommand with this EntityConnection.");
cmd.CommandText = "SELECT VALUE AVG(s.Age) FROM SchoolDbContextEntities.Students as s";
// Execute the command.
using (EntityDataReader rdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// Start reading results.
while (rdr.Read())
{
IExtendedDataRecord record = rdr as IExtendedDataRecord;
// For PrimitiveType
// the record contains exactly one field.
int fieldIndex = 0;
Console.WriteLine("Value: " + record.GetValue(fieldIndex));
}
}
conn.Close();
}
}
}
catch (Exception ex)
{
Console.Error.WriteLine(ex);
return((int)ExitCode.UnknownError);
}
return((int)ExitCode.Success);
}
static int Main(string[] args)
{
try
{
using (var ctx = new SchoolDbContextEntities())
{
// create database if missing
ctx.Database.CreateIfNotExists();
var student = new Student()
{
StudentName = "Bill", Age = 12
};
ctx.Students.Add(student);
ctx.SaveChanges();
// Call ObjectContext.ExecuteStoreQuery which invokes the bad behavior
// where a branch jumps directly to the method call instruction, which
// throws an InvalidProgramException if we incorrectly load our custom
// method arguments BEFORE the original method call instruction.
var objContext = (ctx as IObjectContextAdapter).ObjectContext;
if (objContext != null)
{
SqlParameter paramName = new SqlParameter("name", "Bill");
var results = objContext.ExecuteStoreQuery <Student>("SELECT * FROM dbo.Students WHERE StudentName = @name", new ExecutionOptions(MergeOption.AppendOnly), paramName);
foreach (var result in results)
{
Console.WriteLine($"ExecuteStoreQuery<Student> result: StudentName={result.StudentName},Age={result.Age}");
}
}
}
// Specify the provider name, server and database.
string providerName = "System.Data.SqlClient";
string serverName = @"(localdb)\MSSQLLocalDB";
string databaseName = "SchoolDbContext";
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder();
// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = databaseName;
sqlBuilder.IntegratedSecurity = true;
// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
new EntityConnectionStringBuilder();
//Set the provider name.
entityBuilder.Provider = providerName;
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = providerString;
// Set the Metadata location.
entityBuilder.Metadata = @"res://*/SchoolModel.csdl|
res://*/SchoolModel.ssdl|
res://*/SchoolModel.msl";
Console.WriteLine(entityBuilder.ToString());
using (EntityConnection conn =
new EntityConnection(entityBuilder.ToString()))
{
conn.Open();
using (EntityCommand cmd = conn.CreateCommand())
{
Console.WriteLine("Creating an EntityCommand with this EntityConnection.");
cmd.CommandText = "SELECT VALUE AVG(s.Age) FROM SchoolDbContextEntities.Students as s";
// Execute the command.
using (EntityDataReader rdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// Start reading results.
while (rdr.Read())
{
IExtendedDataRecord record = rdr as IExtendedDataRecord;
// For PrimitiveType
// the record contains exactly one field.
int fieldIndex = 0;
Console.WriteLine("Value: " + record.GetValue(fieldIndex));
}
}
conn.Close();
}
}
}
catch (Exception ex)
{
Console.Error.WriteLine(ex);
return((int)ExitCode.UnknownError);
}
#if NETCOREAPP2_1
// Add a delay to avoid a race condition on shutdown: https://github.com/dotnet/coreclr/pull/22712
// This would cause a segmentation fault on .net core 2.x
System.Threading.Thread.Sleep(5000);
#endif
return((int)ExitCode.Success);
}
