Guest User

Untitled

a guest
Mar 23rd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
  2. entityBuilder.Provider = "System.Data.SQLite.EF6";
  3. entityBuilder.ConnectionString = @"F:RISQ-RDM-MODLibrary_MODSinergiModReporting_DEV_20180319_181642.db";
  4.  
  5. var temp = new List<string>();
  6. using (var con = new EntityConnection(entityBuilder.ToString()))
  7. {
  8.  
  9. con.Open();
  10. EntityCommand cmd = con.CreateCommand();
  11. cmd.CommandText = "SELECT name FROM dim_Tasks";
  12.  
  13. using (EntityDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection))
  14. {
  15. while (reader.Read())
  16. {
  17. temp.Add(reader.GetString(1));
  18. }
  19. }
  20. }
Add Comment
Please, Sign In to add comment