本文整理汇总了C#中System.Data.EntityClient.EntityConnection.Open方法的典型用法代码示例。如果您正苦于以下问题:C# EntityConnection.Open方法的具体用法?C# EntityConnection.Open怎么用?C# EntityConnection.Open使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.EntityClient.EntityConnection
的用法示例。
在下文中一共展示了EntityConnection.Open方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Main
static void Main(string[] args)
{
using (var c = new EntityConnection("name=AdventureWorksEntities"))
{
c.StateChange += EStateChange;
var cmd = "SELECT VALUE C FROM AdventureWorksEntities.Contatos AS C WHERE [email protected]";
using (var k = new EntityCommand(cmd, c))
{
k.Parameters.AddWithValue("ContactID", 1);
c.Open();
var dr = k.ExecuteReader(CommandBehavior.SequentialAccess);
if (dr.Read()) //while se existir mais de um registro
{
Console.WriteLine(dr["Nome"]);
}
if (c.State != ConnectionState.Closed) c.Close();
}
}
Console.ReadKey();
}
示例2: Test1
public void Test1()
{
string SELECT_PERSONS_ALL = "SELECT p.id as person_id, p.fname, p.lname, ph.id as phone_id , " +
"ph.phonevalue as phonevalue, a.id as address_id , a.addressvalue as addressvalue " +
"FROM Entities.People as p INNER JOIN Entities.Addresses as a ON a.personid = p.id " +
"INNER JOIN Entities.Phones as ph ON ph.personid = p.id";
EntityConnection m_connection = new EntityConnection("name=Entities");
List<Mock.PhoneBook.Phone> list = new List<Mock.PhoneBook.Phone>();
m_connection.Open();
Infrastructure.PhoneBook.IMockConvertor convertor = new ERDBArch.Modules.PhoneBook.BLL.PersonConvertor();
using (EntityCommand cmd = new EntityCommand(SELECT_PERSONS_ALL, m_connection))
{
using (DbDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
System.Diagnostics.Debug.WriteLine(reader["person_id"]);
}
}
}
m_connection.Close();
}
示例3: FunWithEntityDataReader
private static void FunWithEntityDataReader()
{
// Make a connection object, based on our *.config file.
using (EntityConnection cn = new EntityConnection("name=AutoLotEntities"))
{
cn.Open();
// Now build an Entity SQL query.
string query = "SELECT VALUE car FROM AutoLotEntities.Cars AS car";
// Create a command object.
using (EntityCommand cmd = cn.CreateCommand())
{
cmd.CommandText = query;
// Finally, get the data reader and process records.
using (EntityDataReader dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (dr.Read())
{
Console.WriteLine("***** RECORD *****");
Console.WriteLine("ID: {0}", dr["CarID"]);
Console.WriteLine("Make: {0}", dr["Make"]);
Console.WriteLine("Color: {0}", dr["Color"]);
Console.WriteLine("Pet Name: {0}", dr["CarNickname"]);
Console.WriteLine();
}
}
}
}
}
示例4: ReadContents
public static void ReadContents()
{
using (EntityConnection cn = new EntityConnection("name=DESEDMEntities"))
{
cn.Open();
string query = "SELECT VALUE DESContent FROM DESEDMEntities.DESContents AS DESContent";
using (EntityCommand cmd = cn.CreateCommand())
{
cmd.CommandText = query;
// Finally, get the data reader and process records.
using (EntityDataReader dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
Console.WriteLine("Count: " + dr.FieldCount);
Console.WriteLine("Row:" + dr.HasRows);
if (dr.HasRows)
{
while (dr.Read())
{
Console.WriteLine("****RECORD*****");
Console.WriteLine("ID: {0}", dr["Id"]);
Console.WriteLine("Input File Name: {0}", dr["InputFileName"]);
Console.WriteLine("Output File Name: {0}", dr["OutputFileName"]);
}
}
}
}
}
}
示例5: RunESQLExample
public static void RunESQLExample()
{
System.Console.WriteLine("\nUsing Entity SQL");
var esqlQuery = @"SELECT order.SalesOrderID, order.OrderDate, order.DueDate, order.ShipDate FROM AdventureWorksEntities.SalesOrderHeaders AS order where order.SalesOrderID = 43661";
using (var 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())
{
System.Console.WriteLine("\nSalesOrderID: {0} \nOrderDate: {1} \nDueDate: {2} \nShipDate: {3}", rdr[0], rdr[1], rdr[2], rdr[3]);
}
}
}
conn.Close();
}
}
示例6: AlcionaDataBaseConnection
private AlcionaDataBaseConnection()
{
EntityConnection connection = new EntityConnection();
string connectionString = ConfigurationManager.ConnectionStrings["AlcionaEntities"].ConnectionString;
connection.ConnectionString = connectionString;
connection.Open();
_context = new AlcionaEntities(connection, false);
((IObjectContextAdapter)_context).ObjectContext.CommandTimeout = 3600;
}
示例7: GetGenres
public Genre[] GetGenres()
{
Genre[] genres = null;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("SELECT g.genreid, g.genre1 FROM tunesEntities.titel AS a");
stringBuilder.Append(" INNER JOIN tunesEntities.genre AS g ON a.genreid = g.genreid");
stringBuilder.Append(" INNER JOIN tunesEntities.lieder AS t ON a.TitelID = t.TitelID");
stringBuilder.Append(" WHERE t.Liedpfad IS NOT NULL");
stringBuilder.Append(" GROUP BY g.genreid, g.genre1");
stringBuilder.Append(" ORDER BY g.genre1");
using (System.Data.EntityClient.EntityConnection entityConnection =
new System.Data.EntityClient.EntityConnection(this.ConnectionString))
{
try
{
entityConnection.Open();
using (EntityCommand entityCommand = entityConnection.CreateCommand())
{
List<Genre> genreCollection = null;
entityCommand.CommandText = stringBuilder.ToString();
// Execute the command.
using (EntityDataReader dataReader =
entityCommand.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
// Start reading results.
while (dataReader.Read())
{
IDataReader dataR = dataReader;
if (genreCollection == null)
{
genreCollection = new List<Genre>();
}
Genre genre = new Genre
{
Id = dataReader.GetInt32("genreid", false, 0),
Name = dataReader.GetString("genre1", false, string.Empty)
};
genreCollection.Add(genre);
}
}
if (genreCollection != null)
{
genres = genreCollection.ToArray();
}
}
}
finally
{
entityConnection.Close();
}
}
return genres;
}
示例8: ExecuteESqlQuery
internal static void ExecuteESqlQuery(string cxString, string query)
{
EntityConnection connection = new EntityConnection(cxString);
EntityCommand command = new EntityCommand(query, connection);
connection.Open();
try
{
command.ExecuteReader(CommandBehavior.SequentialAccess).Dump<EntityDataReader>();
}
finally
{
connection.Close();
}
}
示例9: InitializeThreadProc
static DictionaryEntities InitializeThreadProc()
{
string providerString = "Data Source=Dictionary.sdf";
string providerName = "System.Data.SqlServerCe.3.5";
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
entityBuilder.Provider = providerName;
entityBuilder.ProviderConnectionString = providerString;
entityBuilder.Metadata = @"Res://ER/";
var connection = new EntityConnection(entityBuilder.ToString());
connection.Open();
var entities = new DictionaryEntities(connection);
return entities;
}
示例10: GetEntityConnection
/// <summary>
/// Gets the DB connection
/// connection parameters are decrypted
/// </summary>
/// <returns>An Entity (Framework) connection</returns>
public static EntityConnection GetEntityConnection(string serverURI)
{
EntityConnection ans = null;
EntityConnection conn = null;
try
{
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder =
new EntityConnectionStringBuilder();
// Set the provider name.
entityBuilder.Provider = "MySql.Data.MySqlClient";
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = GetSqlBuilder(serverURI).ToString();
// Set the Metadata location.
entityBuilder.Metadata = @"res://*/Entities.BourseEntities.csdl|res://*/Entities.BourseEntities.ssdl|res://*/Entities.BourseEntities.msl";
string st = entityBuilder.ToString();
conn = new EntityConnection(entityBuilder.ToString());
conn.Open();
// Just testing the connection.
conn.Close();
// CA2000 prevention
ans = conn;
conn = null;
return ans;
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
示例11: GetEntityCount
protected int GetEntityCount(string esqlQuery)
{
int count = 0;
using (var connection = new EntityConnection(AboutInheritanceEntitiesConnectionString))
{
connection.Open();
using (var command = new EntityCommand(esqlQuery, connection))
{
using (var reader = command.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
count = count + 1;
}
}
}
}
return count;
}
示例12: Main
static void Main(string[] args)
{
using (EntityConnection ec = new EntityConnection("name=VS2010Entities"))
{
ec.Open();
String sql = "SELECT VALUE PESSOA FROM VS2010Entities.PESSOA";
using (EntityCommand ek = ec.CreateCommand())
{
ek.CommandText = sql;
using (EntityDataReader edr = ek.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (edr.Read())
{
Console.WriteLine("{0} - {1} - {2}", edr["COD_PESSOA"], edr["NOME_PESSOA"], edr["SEXO_PESSOA"]);
}
}
}
}
Console.ReadKey();
}
示例13: GetPlaylistsByUserName
public Playlist[] GetPlaylistsByUserName(string userName, int limit)
{
Playlist[] playlists = null;
if (!string.IsNullOrEmpty(userName))
{
bool hasLimit = false;
if (limit > 0)
{
hasLimit = true;
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("SELECT p.ListId, p.ListName, p.User, p.guid FROM tunesEntities.playlist AS p");
stringBuilder.Append(" WHERE p.User = @userName");
stringBuilder.Append(" ORDER BY p.ListName");
if (hasLimit)
{
stringBuilder.Append(" LIMIT @limit ");
}
string sql = stringBuilder.ToString();
using (System.Data.EntityClient.EntityConnection entityConnection =
new System.Data.EntityClient.EntityConnection(this.ConnectionString))
{
try
{
entityConnection.Open();
using (EntityCommand entityCommand = entityConnection.CreateCommand())
{
EntityParameter user = new EntityParameter();
user.ParameterName = "userName";
user.Value = userName;
entityCommand.Parameters.Add(user);
EntityParameter limitParam = new EntityParameter();
limitParam.ParameterName = "limit";
limitParam.Value = limit;
entityCommand.Parameters.Add(limitParam);
List<Playlist> playlistCollection = null;
entityCommand.CommandText = sql;
// Execute the command.
using (EntityDataReader dataReader = entityCommand.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
// Start reading results.
while (dataReader.Read())
{
if (playlistCollection == null)
{
playlistCollection = new List<Playlist>();
}
Playlist playlist = new Playlist
{
Id = dataReader.GetInt32("ListId", false, 0),
Name = dataReader.GetString("ListName", false, string.Empty),
UserName = dataReader.GetString("User", false, string.Empty),
Guid = dataReader.GetGuid("guid", true, Guid.Empty)
};
playlistCollection.Add(playlist);
}
}
if (playlistCollection != null)
{
playlists = playlistCollection.ToArray();
}
}
}
finally
{
entityConnection.Close();
}
}
}
return playlists;
}
示例14: GetPlaylistById
public Playlist GetPlaylistById(int playlistId, string userName)
{
Playlist playlist = null;
if (string.IsNullOrEmpty(userName) == false)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("SELECT p.ListId, p.ListName, p.User, p.Guid, pe.EntryId, pe.sortorder, pe.Guid as EntryGuid, t.LiedID, t.Lied, t.Dauer, a.Guid as AlbumId, i.Interpret FROM tunesEntities.playlist AS p");
stringBuilder.Append(" LEFT JOIN tunesEntities.playlistentries AS pe ON p.ListId = pe.PlaylistId");
stringBuilder.Append(" LEFT JOIN tunesEntities.lieder AS t ON pe.LiedId = t.LiedID");
stringBuilder.Append(" LEFT JOIN tunesEntities.titel AS a ON t.TitelID = a.TitelID");
stringBuilder.Append(" LEFT JOIN tunesEntities.interpreten AS i ON a.InterpretID = i.InterpretID");
stringBuilder.Append(" WHERE p.ListId = @playlistId");
stringBuilder.Append(" AND p.User = @userName");
string sql = stringBuilder.ToString();
using (System.Data.EntityClient.EntityConnection entityConnection =
new System.Data.EntityClient.EntityConnection(this.ConnectionString))
{
try
{
entityConnection.Open();
using (EntityCommand entityCommand = entityConnection.CreateCommand())
{
EntityParameter trackIdParam = new EntityParameter();
trackIdParam.ParameterName = "playlistId";
trackIdParam.Value = playlistId;
entityCommand.Parameters.Add(trackIdParam);
EntityParameter user = new EntityParameter();
user.ParameterName = "userName";
user.Value = userName;
entityCommand.Parameters.Add(user);
entityCommand.CommandText = sql;
// Execute the command.
using (EntityDataReader dataReader = entityCommand.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
// Start reading results.
while (dataReader.Read())
{
if (playlist == null)
{
playlist = new Playlist
{
Id = dataReader.GetInt32("ListId", false, 0),
Name = dataReader.GetString("ListName", false, string.Empty),
UserName = dataReader.GetString("User", false, string.Empty),
Guid = dataReader.GetGuid("Guid", false, Guid.Empty),
};
}
int entryId = dataReader.GetInt32("EntryId", true, 0);
if (entryId > 0)
{
PlaylistEntry entry = new PlaylistEntry
{
Id = entryId,
SortOrder = dataReader.GetInt32("sortorder", true, 0),
Guid = dataReader.GetGuid("EntryGuid", true, Guid.Empty),
TrackId = dataReader.GetInt32("LiedID", true, 0),
Name = dataReader.GetString("Lied", true, string.Empty),
Duration = dataReader.GetTimeSpan("Dauer", true, TimeSpan.MinValue),
AlbumId = dataReader.GetGuid("AlbumId", false, Guid.Empty),
Artist = dataReader.GetString("Interpret", true, string.Empty)
};
playlist.Entries.Add(entry);
}
}
}
}
}
finally
{
entityConnection.Close();
}
}
}
return playlist;
}
示例15: GetPlaylistImageIdsById
public ICollection<Guid> GetPlaylistImageIdsById(int playlistId, string userName, int limit)
{
Collection<Guid> imageIds = null;
if (string.IsNullOrEmpty(userName) == false)
{
StringBuilder stringBuilder = new StringBuilder();
//stringBuilder.Append("SELECT a.Guid, COUNT(a.Guid) AS Number FROM tunesEntities.playlist AS p");
stringBuilder.Append("SELECT a.Guid FROM tunesEntities.playlist AS p");
stringBuilder.Append(" LEFT JOIN tunesEntities.playlistentries AS pe ON p.ListId = pe.PlaylistId");
stringBuilder.Append(" LEFT JOIN tunesEntities.lieder AS t ON pe.LiedId = t.LiedID");
stringBuilder.Append(" LEFT JOIN tunesEntities.titel AS a ON t.TitelID = a.TitelID");
stringBuilder.Append(" WHERE p.ListId = @playlistId");
stringBuilder.Append(" AND p.User = @userName");
stringBuilder.Append(" ORDER BY pe.sortorder");
stringBuilder.Append(" LIMIT @limit ");
string sql = stringBuilder.ToString();
using (System.Data.EntityClient.EntityConnection entityConnection =
new System.Data.EntityClient.EntityConnection(this.ConnectionString))
{
try
{
entityConnection.Open();
using (EntityCommand entityCommand = entityConnection.CreateCommand())
{
EntityParameter idParam = new EntityParameter();
idParam.ParameterName = "playlistId";
idParam.Value = playlistId;
entityCommand.Parameters.Add(idParam);
EntityParameter user = new EntityParameter();
user.ParameterName = "userName";
user.Value = userName;
entityCommand.Parameters.Add(user);
EntityParameter limitParam = new EntityParameter();
limitParam.ParameterName = "limit";
limitParam.Value = limit;
entityCommand.Parameters.Add(limitParam);
entityCommand.CommandText = sql;
// Execute the command.
using (EntityDataReader dataReader = entityCommand.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
while (dataReader.Read())
{
if (imageIds == null)
{
imageIds = new Collection<Guid>();
}
imageIds.Add(dataReader.GetGuid("Guid", true, Guid.Empty));
}
}
}
}
finally
{
entityConnection.Close();
}
}
}
return imageIds;
}