asp.net mvc 3 - How to want to move my DAL to separate project in my MVC3 solution? -

-

i have mvc 3 application uses dal (ado.net) communicates set of tsql stored procedures? want add new mvc project current solution. need have dal in separate project 2 mvc project ("monitor" , "audit") can share.

here's current dal (which sits in folder of "monitor" mvc project) code below. issue have signature ienumerable located in monitor.models , ienumerable located in audit.models. need make dal generic avoid needing make references models in dal? 

ex:  **//is bad practice?**     using monitor.models;     using adit.models;    namespace monitor.dal {     public class questiondal     {         static ilog log = log4net.logmanager.getlogger(typeof(questiondal));         private string _connectionstring = webconfigurationmanager.connectionstrings["nexgencontext"].tostring();          public ienumerable<agencyterm> searchagencies(string ori, string name)         {             log.debug("executing: searchagencies(string ori, string name)");             list<agencyterm> agencies = new list<agencyterm>();             using (var conn = new sqlconnection(_connectionstring))             {                 var com = new sqlcommand();                 com.connection = conn;                 com.commandtype = commandtype.storedprocedure;                 string term = "ori";                  if (!string.isnullorempty(ori))                  {                    term = "ori";                    com.parameters.add(new sqlparameter                    {                         parametername = "@ori",                         value = ori                     });                 }                 if (!string.isnullorempty(name))                 {                     term = "legal_name";                     com.parameters.add(new sqlparameter                     {                         parametername = "@name",                         value = name                     });                 }                 com.commandtext = "review_get_agency_list";                 var adapt = new sqldataadapter();                 adapt.selectcommand = com;                 var dataset = new dataset();                 adapt.fill(dataset);                  agencies = (from c in dataset.tables[0].asenumerable()                             select new agencyterm()                                          {                                              label = c[term].tostring(),                                              id = c["agency_id"].tostring()                                          }).tolist<agencyterm>();                  return agencies;             }          }          public ienumerable<user> getusers()         {             log.debug("executing: getusers()");             list<user> users = new list<user>();             using (var conn = new sqlconnection(_connectionstring))             {                 var com = new sqlcommand();                 com.connection = conn;                 com.commandtype = commandtype.storedprocedure;                 com.commandtext = "review_get_users";                 var adapt = new sqldataadapter();                 adapt.selectcommand = com;                 var dataset = new dataset();                 adapt.fill(dataset);                  users = (from c in dataset.tables[0].asenumerable()                             select new user()                             {                                 user_id = convert.toint32(c["user_id"]),                                 department = c["department"].tostring(),                                 enabled = convert.toboolean(c["enabled"]),                                 email = c["email"].tostring(),                                 user_first_name = c["user_first_name"].tostring(),                                 user_last_name = c["user_last_name"].tostring(),                                 location = c["location"].tostring(),                                 user_name = c["user_name"].tostring()                             }).tolist<user>();                  return users;             }          }

you have 2 possibilities:

  • either move model separate library , reference mvc project , dal
  • make dal generic , push values inside. don't see easy way here though since have lot of information in dal

i go first option. extract models different project , reuse library in both dal , mvc-projects


Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused...
Read more

What is the difference between data design and data model(ERD) -

-
i have google question , find answer in day. know, data design many many table have list column,and mark pk , fk. why er-diagram have find this? data design process of designing database. main output of data design detailed logical data model of database. some people data design includes of needed logical , physical design choices , physical storage parameters needed generate design in data definition language. technically, database analysis, database analysts (dbas) trained do. while person can both data design , database analysis, these 2 different tasks. data design models data. database analysis takes model , applies 1 or more database engines (relational, hierarchical, nosql). a logical data model 1 of main outputs of data design. data model represented entity relationship diagram, or er diagram.
Read more

ios - Can NSManagedObject conform to NSCoding -

-
i need transfer single object across device. right converting nsmanagedobject dictionary , archiving , sending nsdata. upon receiving unarchiving it. transfer nsmanagedobject archiving , unarchiving instead of creating intermediate data object. @interface test : nsmanagedobject<nscoding> @property (nonatomic, retain) nsstring * title; @end @implementation test @dynamic title; - (id)initwithcoder:(nscoder *)coder { self = [super init]; if (self) { self.title = [coder decodeobjectforkey:@"title"]; //<crash } return self; } - (void)encodewithcoder:(nscoder *)coder { [coder encodeobject:self.title forkey:@"title"]; } @end nsdata *archivedobjects = [nskeyedarchiver archiveddatawithrootobject:testobj]; nsdata *objectsdata = archivedobjects; if ([objectsdata length] > 0) { nsarray *objects = [nskeyedunarchiver unarchiveobjectwithdata:objectsdata]; } the problem above code is. crashes @ self.title in initwithcoder sa...
Read more