c# - How to connect to a MySQL database inside the .NET framework? -

-

i'm opening discussion here on subject couldn't find answer enough called final answer: mysql , .net.

while know there lot of ways make connection, i'm trying find list of pros , cons of each approach.

i've been using ado.net mysql netconnector since beggining of project, , ok when database new , didn't have many records. i'm facing situation number of records grows exponentially, , found other way of querying against database, odbc connector. using ado.net + netconnector solution had o/rm , didn't have write queries, while odbc makes code awful (since didn't switch odbc, have linq queries , plain sql queries inside code).

is there solution (free or not) can have both o/rm without need of writing sql queries myself , speed of odbc?

what should doing using mysql ado.net connector , storing queries in database in form of stored procedures. version 6.0 of mysql connector supports the entity framework. if interested in using entity framework, check out this link describes how set up.


Comments

Post a Comment

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

-
i new in xmlreader, , think kind of hard find tutorials/code or advanced examples. question how can transform code have now, if search (through form) term jquery give me opportunity output value of <info></info> (and later other elements) in every <name></name> found in ? this code output names of books. <?php $reader = new xmlreader(); $reader->open("books.xml"); while ($reader->read()) { switch ($reader->nodetype) { case (xmlreader::element): if ($reader->localname == "name") { $reader->read(); echo $reader->value; break; }}} ?> the xml file <?xml version="1.0" encoding="iso-8859-1"?> <library> <book isbn="781"> <name>scjp 1.5</name> <info>sun certified java programmer book</info> </book> <bo...
Read more

iphone - Pop a UIViewController containing a UITabBarController off of a UINavigationController -

-
i have uinavigationcontroller(a) pushes uiviewcontroller(b) onto stack. (b) contains uitabbarcontroller(c). (c) has 5 tabs , of these viewcontrollers(d,e,f,g,h) needs able pop (b) off stack. i've tried [[self.parentviewcontroller navigationcontroller] popviewcontrolleranimated:yes]; among many other things, none of seem work. ideas? edit: .h file: @interface matabviewcontroller : uiviewcontroller<uitabbarcontrollerdelegate> { uiviewcontroller *ref; } @property (nonatomic, retain) iboutlet uitabbarcontroller *tabbarcontroller; @property (nonatomic, retain) iboutlet uiimageview *imgviewfooter; @end .m: #import "matabviewcontroller.h" @implementation matabviewcontroller @synthesize tabbarcontroller = _tabbarcontroller; @synthesize imgviewfooter; - (void)viewdidload { [super viewdidload]; self.view = self.tabbarcontroller.view; self.tabbarcontroller.delegate = self; self.imgviewfooter.frame = cgrectmake(0.0f, 395.0f, 320.0f, 64.0f); [self.tabbarcon...
Read more