Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
- entityBuilder.Provider = "System.Data.SQLite.EF6";
- entityBuilder.ConnectionString = @"F:RISQ-RDM-MODLibrary_MODSinergiModReporting_DEV_20180319_181642.db";
- var temp = new List<string>();
- using (var con = new EntityConnection(entityBuilder.ToString()))
- {
- con.Open();
- EntityCommand cmd = con.CreateCommand();
- cmd.CommandText = "SELECT name FROM dim_Tasks";
- using (EntityDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection))
- {
- while (reader.Read())
- {
- temp.Add(reader.GetString(1));
- }
- }
- }
Add Comment
Please, Sign In to add comment