Click here to Skip to main content
15,881,769 members
Home / Discussions / C#
   

C#

 
AnswerRe: Create Microsoft Excel in C# Pin
Richard Deeming25-Jun-14 1:32
mveRichard Deeming25-Jun-14 1:32 
SuggestionRe: Create Microsoft Excel in C# Pin
LucasRLS25-Jun-14 1:57
LucasRLS25-Jun-14 1:57 
AnswerRe: Create Microsoft Excel in C# Pin
Nguyen.H.H.Dang25-Jun-14 18:45
professionalNguyen.H.H.Dang25-Jun-14 18:45 
QuestionDbContext recreate with cache clear Pin
Nathan Minier24-Jun-14 3:25
professionalNathan Minier24-Jun-14 3:25 
AnswerRe: DbContext recreate with cache clear Pin
Dave Kreskowiak24-Jun-14 5:04
mveDave Kreskowiak24-Jun-14 5:04 
GeneralRe: DbContext recreate with cache clear Pin
Nathan Minier24-Jun-14 5:52
professionalNathan Minier24-Jun-14 5:52 
GeneralRe: DbContext recreate with cache clear Pin
Dave Kreskowiak24-Jun-14 6:00
mveDave Kreskowiak24-Jun-14 6:00 
GeneralRe: DbContext recreate with cache clear Pin
Nathan Minier24-Jun-14 6:22
professionalNathan Minier24-Jun-14 6:22 
According to the MSDN[^] documentation the cache is created on first instantiation and tied to the AppDomain. To an extent that is my issue, because I cannot reset that cache. I can inject new IModels in at runtime and they are not included in new instances of the DbContext until the application is restarted, at which point OnModelCreating is called again. This implies to me that the cache is functioning as intended. The population of the context model is happening just once, as is efficient, but I would like to bump it when an extension is added to re-build the context model again.

Fortunately the DbContext doesn't actually execute any SQL until an IQuryable has a terminal method run on it, such as .Single, .First, or .toList; I agree that it would be mind-numbingly inefficient if it did. Instead, after the initial context creation it automatically caches the specific implementation of DbContext so that it holds the ORM but not the table data. Future instances come from this cache instead of being generated at runtime. It's pretty slick, honestly, and does perform nicely. My only complaint is the completely crazy statements it generates for Table-Per-Type implementations (which model polymorphism much better than Table-Per-Hierarchy or Table-Per-Class) and, of course, this cache refresh obnoxiousness.

I think I understand the communication breakdown here. I'm not interested in the data, I want to call that per request in accordance with the UnitOfWork pattern. I want to find that DbContext model cache and refresh it when a new extension is loaded.
GeneralRe: DbContext recreate with cache clear Pin
Dave Kreskowiak24-Jun-14 6:54
mveDave Kreskowiak24-Jun-14 6:54 
GeneralRe: DbContext recreate with cache clear Pin
Nathan Minier24-Jun-14 9:49
professionalNathan Minier24-Jun-14 9:49 
QuestionProgramming Visio streams on a local computer and hosted on a remote server using c# Pin
orélle23-Jun-14 22:25
orélle23-Jun-14 22:25 
AnswerRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Kornfeld Eliyahu Peter23-Jun-14 22:38
professionalKornfeld Eliyahu Peter23-Jun-14 22:38 
GeneralRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
orélle23-Jun-14 23:20
orélle23-Jun-14 23:20 
AnswerRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Kornfeld Eliyahu Peter23-Jun-14 23:23
professionalKornfeld Eliyahu Peter23-Jun-14 23:23 
GeneralRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
orélle24-Jun-14 1:03
orélle24-Jun-14 1:03 
AnswerRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Kornfeld Eliyahu Peter24-Jun-14 1:21
professionalKornfeld Eliyahu Peter24-Jun-14 1:21 
GeneralRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
orélle24-Jun-14 2:20
orélle24-Jun-14 2:20 
AnswerRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Kornfeld Eliyahu Peter24-Jun-14 2:29
professionalKornfeld Eliyahu Peter24-Jun-14 2:29 
GeneralRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Dave Kreskowiak24-Jun-14 1:39
mveDave Kreskowiak24-Jun-14 1:39 
SuggestionRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Richard Deeming24-Jun-14 0:38
mveRichard Deeming24-Jun-14 0:38 
GeneralRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
OriginalGriff24-Jun-14 1:06
mveOriginalGriff24-Jun-14 1:06 
GeneralRe: Programming Visio streams on a local computer and hosted on a remote server using c# Pin
Mycroft Holmes25-Jun-14 0:39
professionalMycroft Holmes25-Jun-14 0:39 
QuestionHow to convert a text file in unicode format to excel file Pin
botngot8323-Jun-14 20:54
botngot8323-Jun-14 20:54 
SuggestionRe: How to convert a text file in unicode format to excel file Pin
Nathan Minier24-Jun-14 3:12
professionalNathan Minier24-Jun-14 3:12 
QuestionConnect to MySQL using MySQL Connector.NET and SharpSsh Pin
Jassim Rahma23-Jun-14 20:24
Jassim Rahma23-Jun-14 20:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.