{"id":7334,"date":"2014-06-07T02:26:30","date_gmt":"2014-06-07T02:26:30","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/problem-about-dblinq-collection-of-common-programming-errors\/"},"modified":"2014-06-07T02:26:30","modified_gmt":"2014-06-07T02:26:30","slug":"problem-about-dblinq-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/problem-about-dblinq-collection-of-common-programming-errors\/","title":{"rendered":"problem about dblinq-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/3a03c20e821a892b9e1e368d93233907?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nell<br \/>\nasp.net mono monodevelop dblinq xsp2<br \/>\nI am trying to try DBLinq with the sqlite provider inside a simple ASP.NET web service. I am also using MonoDevelop 2.4 and Mono 2.6.7, The project in monodevelop references the DbLinq.dll which by default is set to be Local Copy. I can compile the webservice just fine. By when I try to run it from Monodevelop or using the xsp2 from the command line, xsp2 fails with a number of errors (see below). If I unchecked the Local Copy for the DBLinq.dll reference, xsp2 will execute but the Li<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/b1d946cf75da5ba2be40f1878b022af0?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nAli Behzadian Nejad<br \/>\nc# winforms sqlite3 dblinq<br \/>\nI have created a Linq and SQLite app in C#\/winform with DBLinq using these two commands:DbMetal \/provider:Sqlite \/conn &#8220;Data Source=path\\to\\database.s3db&#8221; \/dbml:path\\to\\Database.dbmland:DbMetal \/code:path\\to\\DatabaseContext.cs path\\to\\Database.dbmlTo get a connection to database:string dataSource = @&#8221;Data Source=&#8221; + AppDomain.CurrentDomain.BaseDirectory + &#8220;database.s3db&#8221;; var connection = new SQLiteConnection(dataSource); Main db = new Main(connection, new SqliteVendor());And to query database:v<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/df77fbaa0f5da0a73f9fdbae5e5d8d36?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nChief A-G<br \/>\nsqlite mono dblinq<br \/>\nI&#8217;m trying to use the new Mono 2.6 SqlMetal tool to create the DBML file for a simple Sqlite Database. The schema is really simple as follows:CREATE TABLE Tags (Id INTEGER PRIMARY KEY,TagName TEXT,Description TEXT); CREATE TABLE Trends (TagId INTEGER NOT NULL,Timestamp DATETIME NOT NULL,Value TEXT,PRIMARY KEY (tagid, timestamp));I am trying to create the DBML file using the following:sqlmetal.exe \/conn:&#8221;Data Source=MyDatabase.db&#8221; \/namespace:MyN<\/li>\n<\/ul>\n<p>Web site is in building<\/p>\n<p>I discovery a place to host code\u3001demo\u3001 blog and websites.<br \/>\nSite access is fast but not money<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.m5zn.com\/newuploads\/2014\/01\/30\/jpg\/e7da807964b1fff.jpg\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ell asp.net mono monodevelop dblinq xsp2 I am trying to try DBLinq with the sqlite provider inside a simple ASP.NET web service. I am also using MonoDevelop 2.4 and Mono 2.6.7, The project in monodevelop references the DbLinq.dll which by default is set to be Local Copy. I can compile the webservice just fine. By [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7334","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=7334"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7334\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=7334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=7334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=7334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}