c# - How to make a WPF Desktop application accessible over a network -

-

i designing wpf application connects ms sql server database using entity framework.

the application reads data excel file , saves records database. next requirement has come application should accessible multiple users @ same time (company network) users can see data in database , query/update whenever required.

what thinking is, need put database on central machine should on company's internal network , application should connect database , allow users perform operations.

what changes require current connection string?

<connectionstrings>     <add name="tpmscontext" connectionstring="metadata=res://*/tpmsmodel.csdl|res://*/tpmsmodel.ssdl|res://*/tpmsmodel.msl;provider=system.data.sqlclient;provider connection string=&quot;data source=test-dell;initial catalog=tpms;integrated security=true;multipleactiveresultsets=true;app=entityframework&quot;" providername="system.data.entityclient" />   </connectionstrings>

and other changes need implement/keep in mind application work multiple users simultaneously?

p.s: application "any cpu" targeted framework 4.5. right desktop based in future might make web based, want desktop based is. please help.

update this view of solution explorer. tmps main application. tpms.data contains business logic , methods provides interaction database though entity framework. tpms.entities has database tables entity classes.

this approach called 3-tier architecture. can implement wcf tcp/ip hosted on window. host database interaction business logic on other server machine , client consume these apis on other machine.

you need flowing:

  • create service(window) using wcf.
  • host it.
  • generate proxy (interface or contract).
  • distribute proxy clients application needs call , use apis.

you can create architecture of application below:

  • deployed on server machine:

    a) data base access layer (interact database). b) business logic layer (it methods of data base access layer). c) service layer (create wcf services , call business logic methods here). d) host these server machine.

  • client machine - a) create proxy class using .svcutil tool b) use proxy class client machine consuming services (apis)

reference:

host wcf service


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more