public ActionResult Index()
{
Conn.ConnectionString = "Name=PhotoSharingEntities"; //需要把webconfig的屬性+連線名稱都寫出來，N要大寫
var Cmd = Conn.CreateCommand();
//寫sqlCommand時，連同資料庫名稱都要寫上去
Cmd.CommandText = "select p.PhotoID,p.title,c.subject,c.body,c.UserName from PhotoSharingEntities.Photos as p inner join PhotoSharingEntities.comments as c on p.PhotoID=c.PhotoID";
Conn.Open();
var rd = Cmd.ExecuteReader(CommandBehavior.SequentialAccess);
//不一定要arraylist來接資料
ArrayList list = new ArrayList();
while (rd.Read())
{
var data = new
{
PhotoID = rd["PhotoID"].ToString(),
title = rd["title"].ToString(),
subject = rd["subject"].ToString(),
body = rd["body"].ToString(),
UserName = rd["UserName"].ToString()
};
list.Add(data);
}
Conn.Close();
ViewBag.Data = list;
return(View());
}
// GET: EntityPhotoComments
public ActionResult Index()
{
var Cmd = Conn.CreateCommand();
Cmd.CommandText = "select p.PhotoID, p.Title, p.Description, p.CreatedDate, c.Subject, c.Body, c.UserName " +
"from PhotoSharingEntities.photos as p inner join PhotoSharingEntities.comments as c on p.PhotoID=c.PhotoID";
Conn.Open();
var rd = Cmd.ExecuteReader(CommandBehavior.SequentialAccess);
ArrayList list = new ArrayList();
while (rd.Read())
{
var data = new
{
PhotoID = rd["PhotoID"].ToString(),
Title = rd["Title"].ToString(),
Description = rd["Description"].ToString(),
CreatedDate = rd["CreatedDate"].ToString(),
Subject = rd["Subject"].ToString(),
Body = rd["Body"].ToString(),
UserName = rd["UserName"].ToString()
};
list.Add(data);
}
Conn.Close();
ViewBag.Data = list;
return(View());
}
//Querying with EntityClient to return Streamed Data
public void QueryContacts()
{
using (EntityConnection conn = new EntityConnection("name=PEF"))
{
conn.Open();
var queryString = "SELECT VALUE c " +
"FROM PEF.Contact AS c " +
"WHERE c.FirstName = 'Robert'";
EntityCommand cmd = conn.CreateCommand();
cmd.CommandText = queryString;
using (EntityDataReader rdr =
cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess |
System.Data.CommandBehavior.CloseConnection))
{
while (rdr.Read())
{
var firsName = rdr.GetString(1);
var lastName = rdr.GetString(2);
var tittle = rdr.GetString(3);
Console.WriteLine("{0} {1} {2}", tittle.Trim(), firsName.Trim(), lastName);
}
}
conn.Close();
Console.Write("Presiona Enter");
Console.ReadLine();
}
}
// virtual for testing
public virtual StoreSchemaDetails LoadStoreSchemaDetails(IList <EntityStoreSchemaFilterEntry> filters)
{
Debug.Assert(filters != null, "filters != null");
QueryTraceOn9481Interceptor interceptor = null;
try
{
_connection.Open();
interceptor = CreateAndRegisterTrace9481InterceptorIfSqlServer();
return(new StoreSchemaDetails(
LoadTableDetails(filters),
LoadViewDetails(filters),
LoadRelationships(filters),
LoadFunctionDetails(filters),
_storeSchemaModelVersion == EntityFrameworkVersion.Version3
? LoadFunctionReturnTableDetails(filters)
: Enumerable.Empty <TableDetailsRow>()));
}
finally
{
if (interceptor != null)
{
DbInterception.Remove(interceptor);
}
_connection.Close();
}
}
private void CreateEntity()
{
// Specify the provider name, server and database.
string providerName = "System.Data.SqlClient";
string serverName = "data source=dfunkd.database.windows.net;initial catalog=MediaInventory;user id=dylanpfunk4;MultipleActiveResultSets=True;App=EntityFramework";
string databaseName = "RecipesModel";
// 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://*/RecipesModel.csdl|res://*/RecipesModel.ssdl|res://*/RecipesModel.msl";
Console.WriteLine(entityBuilder.ToString());
using (EntityConnection conn = new EntityConnection(entityBuilder.ToString()))
{
conn.Open();
Console.WriteLine("Just testing the connection.");
conn.Close();
}
}
/// <summary>
/// There are no comments for COMP_BIOSUM_VOLS_BY_CURSOR in the schema.
/// </summary>
public virtual void COMP_BIOSUM_VOLS_BY_CURSOR()
{
EntityConnection connection = ((IObjectContextAdapter)this).ObjectContext.Connection as EntityConnection;
bool needClose = false;
if (connection.State != ConnectionState.Open)
{
connection.Open();
needClose = true;
}
try {
using (EntityCommand command = new EntityCommand())
{
if (((IObjectContextAdapter)this).ObjectContext.CommandTimeout.HasValue)
{
command.CommandTimeout = ((IObjectContextAdapter)this).ObjectContext.CommandTimeout.Value;
}
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = @"FCS_Entities.COMP_BIOSUM_VOLS_BY_CURSOR";
command.Connection = connection;
command.ExecuteNonQuery();
}
}
finally {
if (needClose)
{
connection.Close();
}
}
}
//</snippeteSQLStructuralTypes>
//string esqlQuery = @"SELECT REF(p) FROM AdventureWorksEntities.Products as p";
//<snippeteSQLRefTypes>
static public void ExecuteRefTypeQuery(string esqlQuery)
{
if (esqlQuery.Length == 0)
{
Console.WriteLine("The query string is empty.");
return;
}
using (EntityConnection conn =
new EntityConnection("name=AdventureWorksEntities"))
{
conn.Open();
// Create an EntityCommand.
using (EntityCommand cmd = conn.CreateCommand())
{
cmd.CommandText = esqlQuery;
// Execute the command.
using (EntityDataReader rdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// Start reading results.
while (rdr.Read())
{
RefTypeVisitRecord(rdr as IExtendedDataRecord);
}
}
}
conn.Close();
}
}
static public void StoredProcWithEntityCommand()
{
//<snippetStoredProcWithEntityCommand>
using (EntityConnection conn =
new EntityConnection("name=SchoolEntities"))
{
conn.Open();
// Create an EntityCommand.
using (EntityCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SchoolEntities.GetStudentGrades";
cmd.CommandType = CommandType.StoredProcedure;
EntityParameter param = new EntityParameter();
param.Value = 2;
param.ParameterName = "StudentID";
cmd.Parameters.Add(param);
// Execute the command.
using (EntityDataReader rdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// Read the results returned by the stored procedure.
while (rdr.Read())
{
Console.WriteLine("ID: {0} Grade: {1}", rdr["StudentID"], rdr["Grade"]);
}
}
}
conn.Close();
}
//</snippetStoredProcWithEntityCommand>
}
private void testConnection(out string entityConnStr, bool displayAlert)
{
string sqlMgmtConnStr = string.Empty;
Tools.GetConnectionStrings(this.txtDTAServerName.Text, this.txtDTADBName.Text, this.txtMgmtDBName.Text, out entityConnStr, out sqlMgmtConnStr);
using (EntityConnection conn =
new EntityConnection(entityConnStr))
{
conn.Open();
if (displayAlert)
{
MessageBox.Show("Connected to DTA Db sucessfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
conn.Close();
}
using (SqlConnection conn =
new SqlConnection(sqlMgmtConnStr))
{
conn.Open();
if (displayAlert)
{
MessageBox.Show("Connected to Mgmt Db sucessfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
conn.Close();
}
}
private static void QueryEntityClient()
{
using (EntityConnection conn = new EntityConnection(
"name=SampleEntities"))
{
conn.Open();
var query = "SELECT VALUE c " +
"FROM SampleEntities.Contacts AS c " +
"WHERE c.FirstName = 'Robert'";
EntityCommand cmd = conn.CreateCommand();
cmd.CommandText = query;
using (EntityDataReader reader = cmd.ExecuteReader(
CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection))
{
while (reader.Read())
{
var firstname = reader.GetString(1);
var lastname = reader.GetString(2);
var title = reader.GetString(3);
Console.WriteLine("{0} {1} {2}", title.Trim(), firstname.Trim(), lastname);
}
}
conn.Close();
}
}
//Entity Client 相当于实体数据库的操作
static void EntityClient()
{
// 创建并打开连接
EntityConnection conn = new EntityConnection();
//ARTICLE_DBEntities 对应app.config中的配置
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ARTICLE_DBEntities"].ConnectionString;
conn.Open();
// 创建并执行命令
EntityCommand cmd = new EntityCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
/*
* 注意此处特别！！！注意以下两点：
* 1、不支持直接使用 *
* 2、表名前需要添加EDM名称，此处是 ARTICLE_DBEntities
*/
cmd.CommandText = "SELECT T.ID ,T.ZH_NAME ,T.NAME ,T.PWD ,T.ROLES FROM ARTICLE_DBENTITIES.T_USERS AS T";
EntityDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
// 输出
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Console.Write(reader[i].ToString() + "\t");
}
Console.WriteLine();
}
// 关闭连接
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
cn = new EntityConnection("Name=EcoFarm_DBEntities");
cn.Open();
cmd = cn.CreateCommand();
cmd.CommandText = "SELECT VALUE i FROM EcoFarm_DBEntities.Invoice_products as i WHERE i.Name = @product";
cmd.Parameters.AddWithValue("product", ProductsCB.SelectedItem);
DbDataReader dbReader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
dt.Columns.Add("col", "Product code");
dt.Columns.Add("col", "Name");
dt.Columns.Add("col", "Units");
dt.Columns.Add("col", "Number of units");
dt.Columns.Add("col", "Unit price");
dt.Columns.Add("col", "Total price");
dt.Columns.Add("col", "Invoice number");
while (dbReader.Read())
{
dt.Rows.Add(
dbReader["Product_code"].ToString(),
dbReader["Name"].ToString(),
dbReader["Units"].ToString(),
dbReader["Number_of_units"].ToString(),
dbReader["Unit_price"].ToString(),
dbReader["Total_price"].ToString(),
dbReader["Invoice_Number"].ToString()
);
}
dbReader.Close();
cn.Close();
}
protected void CloseConnection()
{
if (Connection.State != System.Data.ConnectionState.Closed)
{
Connection.Close();
}
}
public IEnumerable <Book> Get()
{
var books = new List <Book>();
using (var connection = new EntityConnection("name=DataContext")) {
connection.Open();
string esqlQuery = @"SELECT VALUE books FROM DataContext.Books AS books";
using (var command = connection.CreateCommand())
{
command.CommandText = esqlQuery;
using (var dataReader = command.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (dataReader.Read())
{
var book = new Book();
book.BookId = (int)dataReader["BookId"];
book.Isbn = dataReader["Isbn"] as string;
book.Title = dataReader["Title"] as string;
books.Add(book);
}
}
}
connection.Close();
}
return(books);
}
private List <Product> Query(string connectionString, string commandString)
{
var connection = new EntityConnection(connectionString);
connection.Open();
var command = new EntityCommand(commandString, connection);
var reader = command.ExecuteReader(CommandBehavior.SequentialAccess);
var list = new List <Product>();
do
{
while (reader.Read())
{
var values = new List <object>();
for (var i = 0; i < reader.FieldCount; i++)
{
values.Add(reader.GetFieldValue <object>(i));
}
list.Add(CreateProduct(values));
}
}while (reader.NextResult());
connection.Close();
return(list);
}
private async Task <List <Product> > QueryAsync(string connectionString, string commandString)
{
var connection = new EntityConnection(connectionString);
await connection.OpenAsync();
var command = new EntityCommand(commandString, connection);
var reader = command.ExecuteReaderAsync(CommandBehavior.SequentialAccess).Result;
var list = new List <Product>();
do
{
while (await reader.ReadAsync())
{
var values = new List <object>();
for (var i = 0; i < reader.FieldCount; i++)
{
values.Add(await reader.GetFieldValueAsync <object>(i));
}
list.Add(CreateProduct(values));
}
}while (await reader.NextResultAsync());
connection.Close();
return(list);
}
//</snippeteSQLRefTypes>
//string esqlQuery = @"SELECT VALUE AVG(p.ListPrice) FROM AdventureWorksEntities.Products as p";
//<snippeteSQLPrimitiveTypes>
static void ExecutePrimitiveTypeQuery(string esqlQuery)
{
if (esqlQuery.Length == 0)
{
Console.WriteLine("The query string is empty.");
return;
}
using (EntityConnection conn =
new EntityConnection("name=AdventureWorksEntities"))
{
conn.Open();
// Create an EntityCommand.
using (EntityCommand cmd = conn.CreateCommand())
{
cmd.CommandText = esqlQuery;
// 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();
}
}
static public void NavigateWithNavOperatorWithEntityCommand()
{
//<snippetNavigateWithNavOperatorWithEntityCommand>
using (EntityConnection conn =
new EntityConnection("name=AdventureWorksEntities"))
{
conn.Open();
// Create an EntityCommand.
using (EntityCommand cmd = conn.CreateCommand())
{
// Create an Entity SQL query.
string esqlQuery =
@"SELECT address.AddressID, (SELECT VALUE DEREF(soh) FROM
NAVIGATE(address, AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID)
AS soh) FROM AdventureWorksEntities.Addresses AS address";
cmd.CommandText = esqlQuery;
// Execute the command.
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// Start reading.
while (rdr.Read())
{
Console.WriteLine(rdr["AddressID"]);
}
}
}
conn.Close();
}
//</snippetNavigateWithNavOperatorWithEntityCommand>
}
private static bool IsServerConnected(string connectionString)
{
using var connection = new EntityConnection(connectionString);
try
{
connection.Open();
connection.Close();
connection.Dispose();
return(true);
}
catch (EntityException)
{
connection.Close();
connection.Dispose();
return(false);
}
}
public Int32 checkBollette(Int32 NumBolletta, Int32 QuanteBollette)
{
Int32 retValue = 0;
try
{
using (EntityConnection conn = new EntityConnection(ObjectContext.Connection.ConnectionString))
{
conn.Open();
// Create an EntityCommand.
using (EntityCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "BollettariEntities.checkEsBollette";
cmd.CommandType = CommandType.StoredProcedure;
//retValue = 2;
cmd.Parameters.Clear();
//retValue = 3;
EntityParameter param = new EntityParameter("NumBolletta", System.Data.DbType.Int32);
param.Value = NumBolletta;
cmd.Parameters.Add(param);
//retValue = 4;
param = new EntityParameter("QuanteBollette", System.Data.DbType.Int32);
param.Value = QuanteBollette;
cmd.Parameters.Add(param);
//retValue = 5;
param = new EntityParameter("ret", System.Data.DbType.Int32);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
//retValue = 6;
cmd.ExecuteNonQuery();
//retValue = 7;
retValue = Convert.ToInt32(cmd.Parameters[2].Value.ToString());
//retValue = 8;
//retValue = Int32.Parse(cmd.Parameters["@LastNameCount"].Value.ToString());
//using (EntityDataReader rdr =cmd.ExecuteReader(CommandBehavior.SequentialAccess))
//{
// retValue =Convert.ToInt32 ( cmd.Parameters[2]);
//}
}
conn.Close();
}
}
catch (Exception ex)
{
//retValue = 1000;
//throw new ApplicationException("GeneraBollettario " + ex.Message);
}
//The data reader is incompatible with the specified 'BollettariModel.SP_Result'.
//A member of the type, 'ret', does not have a corresponding column in the data reader with the same name.
return(retValue);
}
static void TestProduct(string esqlQuery, Dictionary <string, object> parametes)
{
using (EntityConnection conn =
new EntityConnection("name=AdventureWorksEntities"))
{
conn.Open();
try
{
// Create an EntityCommand.
using (EntityCommand cmd = conn.CreateCommand())
{
cmd.CommandText = esqlQuery;
foreach (KeyValuePair <string, object> kvp in parametes)
{
cmd.Parameters.AddWithValue(kvp.Key, kvp.Value);
}
// Execute the command.
using (EntityDataReader rdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// The result returned by this query contains
// Address complex Types.
while (rdr.Read())
{
int col = rdr.FieldCount;
if (rdr.FieldCount > 3)
{
col = 3;
}
for (int i = 0; i < col; i++)
{
Console.Write("{0} ", rdr[i]);
}
Console.WriteLine();
if (rdr.Depth > 0)
{
// Display Address information.
DbDataRecord nestedRecord =
rdr[0] as DbDataRecord;
for (int i = 0; i < nestedRecord.FieldCount; i++)
{
Console.WriteLine(" " + nestedRecord.GetName(i) +
": " + nestedRecord.GetValue(i));
}
}
}
}
}
}
catch (EntityException ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
}
}
async private void button31_Click(object sender, EventArgs e)
{
//其實用方法就可以了
//Dynamic LINQ 讓 LINQ 的世界變的更美好
//nuget system.linq.dynamic
//using system.linq.dynamic
db.Database.Log = Console.WriteLine;
var query =
db.Customers.Where("City == @0 and Orders.Count >= @1", "London", 10).
OrderBy("CompanyName").
Select("New (CompanyName as Name, Phone)");
Console.WriteLine(query);
var result = await query.ToListAsync();
this.dataGridView1.DataSource = result;
//============================
using (EntityConnection conn =
new EntityConnection("name=AdventureWorksEntities"))
{
conn.Open();
// Create a query that takes two parameters.
string esqlQuery =
@"SELECT VALUE Contact FROM AdventureWorksEntities.Contacts
AS Contact WHERE Contact.LastName = @ln AND
Contact.FirstName = @fn";
using (EntityCommand cmd = new EntityCommand(esqlQuery, conn))
{
// Create two parameters and add them to
// the EntityCommand's Parameters collection
EntityParameter param1 = new EntityParameter();
param1.ParameterName = "ln";
param1.Value = "Adams";
EntityParameter param2 = new EntityParameter();
param2.ParameterName = "fn";
param2.Value = "Frances";
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
// Iterate through the collection of Contact items.
while (rdr.Read())
{
this.listBox1.Items.Add(rdr["FirstName"]);
this.listBox1.Items.Add(rdr["LastName"]);
}
}
}
conn.Close();
}
}
protected void CloseConnection()
{
if (!IsTransaction)
{
if (entityConnection.State != System.Data.ConnectionState.Closed)
{
entityConnection.Close();
}
}
}
private void btnTestEntityConnection_Click(object sender, EventArgs e)
{
// using (EntityConnection conn = new EntityConnection("metadata=res://*/Models.MCDModel.csdl|res://*/Models.MCDModel.ssdl|res://*/Models.MCDModel.msl;provider=System.Data.SqlClient;provider connection string=\"data source=Localhost;initial catalog=MCD;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework\""))
using (EntityConnection conn = new EntityConnection(this.BuildEntityFrameWorkConnectionString()))
{
conn.Open();
MessageBox.Show("Entity Framework Connection Created and Successfully Connected.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
conn.Close();
}
}
public static void WriteEvent(DataAccessLayer.EventLog log)
{
using (EntityConnection conn = GetConnection())
{
conn.Open();
SLServiceEntities sl = new SLServiceEntities(conn);
sl.AddToEventLog(log);
sl.SaveChanges();
conn.Close();
}
}
static void Main(string[] args)
{
//Database.SetInitializer(new CreateDatabaseIfNotExists<UnderwritingEntitiesContainer>());
//EF_concurrencyfeatures();
using (UnderwritingEntitiesContainer db = new UnderwritingEntitiesContainer())
{
//db.Database.Log = Console.WriteLine;
////use Db table name for Sqlquery
////tightly coupled code
//var headers = db.headers.SqlQuery("Select * from uw.header");
//foreach(var h in headers)
//{
// Console.WriteLine("ID" + h.Id + " value " + h.PolicyReference);
//}
var objectContext = (db as IObjectContextAdapter).ObjectContext;
RunUncompiledQuery(objectContext);
RunCompiledQuery();
//Use EntitySql
//strongly typed
using (EntityConnection connection = objectContext.Connection as EntityConnection)
{
connection.Open();
EntityCommand cmd = connection.CreateCommand();
cmd.CommandText = "Select value header from UnderwritingEntitiesContainer.headers as header";
EntityDataReader dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
while (dr.Read())
{
Console.WriteLine("id " + dr["HeaderId"]);
Console.WriteLine("value " + dr["PolicyReference"]);
}
//ObjectQuery
string query = "select value h from UnderwritingEntitiesContainer.headers as h";
// Use for filter - ObjectParameter
foreach (header h in new ObjectQuery <header>(query, objectContext))
{
Console.WriteLine("id " + h.HeaderId + " policy " + h.PolicyReference);
}
connection.Close();
}
}
Console.ReadKey();
}
private object NonQuery(string connectionString, string commandString)
{
var connection = new EntityConnection(connectionString);
connection.Open();
var command = new EntityCommand(commandString, connection);
var result = command.ExecuteNonQuery();
connection.Close();
return(result);
}
private string BuildConnectionString(MigForwardingConfiguration config)
{
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder
{
// Set the properties for the data source.
DataSource = config.Source,
InitialCatalog = config.Catalog,
MultipleActiveResultSets = true,
ApplicationName = "EntityFramework"
};
if (!config.IntergratedSecurity)
{
sqlBuilder.UserID = config.SqlUsername;
sqlBuilder.Password = config.SqlPassword;
}
sqlBuilder.IntegratedSecurity = config.IntergratedSecurity;
// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();
Console.WriteLine(providerString);
Console.ReadKey();
return(providerString);
// 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://*/AdventureWorksModel.csdl|
// res://*/AdventureWorksModel.ssdl|
// res://*/AdventureWorksModel.msl";
//Console.WriteLine(entityBuilder.ToString());
using (EntityConnection conn =
new EntityConnection(entityBuilder.ToString()))
{
conn.Open();
Console.WriteLine("Just testing the connection.");
conn.Close();
}
}
internal static string GetConnStr(string serverName)
{
// Specify the provider name, server and database.
string providerName = "System.Data.SQLite.EF6";
//string databaseName = "hanriver";
// Initialize the connection string builder for the
// underlying provider.
SqlConnectionStringBuilder sqlBuilder =
new SqlConnectionStringBuilder();
// Set the properties for the data source.
sqlBuilder.DataSource = serverName;
sqlBuilder.Password = "******";
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://*/DB.csdl|
res://*/DB.ssdl|
res://*/DB.msl";
Console.WriteLine(entityBuilder.ToString());
//<add name="hanriverEntities" connectionString="metadata=res://*/HanModel.csdl|res://*/HanModel.ssdl|res://*/HanModel.msl;provider=System.Data.SQLite.EF6;provider connection string='data source="C:\Dropbox\2016_1\환경부 과제\31. 한강유역환경청 RISK MAP project\CARISOne\CARISOne\hanriver.db";password=rhfueo!'" providerName="System.Data.EntityClient" />
try
{
using (EntityConnection conn =
new EntityConnection(entityBuilder.ToString()))
{
conn.Open();
Console.WriteLine("Just testing the connection.");
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(entityBuilder.ToString());
}
private async Task <object> NonQueryAsync(string connectionString, string commandString)
{
var connection = new EntityConnection(connectionString);
await connection.OpenAsync();
var command = new EntityCommand(commandString, connection);
var result = await command.ExecuteNonQueryAsync();
connection.Close();
return(result);
}
