Re: [sqlite] Table Adapter Update Question (Richard W. Kulp)
Roosevelt, Thanks. That worked perfectly. Dick On Wed, 25 Jun 2008 18:17:39 -0400, Roosevelt Anderson <[EMAIL PROTECTED]> wrote: >Try using this library > >http://sqlite.phxsoftware.com/ > >It a complete ADO.NET 2 implementation and it should support the update. > >On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]> >wrote: >> I am trying to convert a VB 2005 program from a SQLExpress database to >> SQLite 3. I have been successful up to the following line of code: >> >> Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) >> >> It seems that the DboTableAdapter does not support the Update command. >> What >> is the preferred way to update a dataset created from a SQLite db? I am >> using CoreLab's dotConnect SQLite data provider. Another consideration is >> that my ultimate goal is to move from Visual Studio to MonoDevelop. >> >> Thanks. >> >> Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question
Robert, I looked at CoreLab's provider recently and didn't get the impression that they used your code at all. It's separate DLL's, very different classes, is missing some functionality that you provide (like custom functions written in .NET) but has other functionality (like robust connection pooling). Also the interop is very different and it uses three dll's, one of which they install to system32 (sucks). We were interested in their product precisely because it is commercial and thus includes support. Lack of custom functions is a deal breaker though--we use them extensively. Richard, CoreLab's product is commercial. Did you try asking their support? In any case, if you're considering a switch to Mono in the future than I'd highly recommend Robert's provider which we use and is very well written and is included with Mono (with some alterations). http://sqlite.phxsoftware.com Thanks, Sam - We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in the Washington D.C. Contact [EMAIL PROTECTED] On Wed, Jun 25, 2008 at 8:17 PM, Robert Simpson <[EMAIL PROTECTED]> wrote: > I'm not exactly sure what they've built on top of my (free) provider, but > it > looks like a good portion of their core codebase is my code. It's a bummer > they decided to split with the free spirit of SQLite and charge for their > provider (based on my public domain code), but to each his own. > > Robert > http://sqlite.phxsoftware.com > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question
I'm not exactly sure what they've built on top of my (free) provider, but it looks like a good portion of their core codebase is my code. It's a bummer they decided to split with the free spirit of SQLite and charge for their provider (based on my public domain code), but to each his own. Robert http://sqlite.phxsoftware.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard W. Kulp Sent: Wednesday, June 25, 2008 2:15 PM To: sqlite-users@sqlite.org Subject: [sqlite] Table Adapter Update Question I am trying to convert a VB 2005 program from a SQLExpress database to SQLite 3. I have been successful up to the following line of code: Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) It seems that the DboTableAdapter does not support the Update command. What is the preferred way to update a dataset created from a SQLite db? I am using CoreLab's dotConnect SQLite data provider. Another consideration is that my ultimate goal is to move from Visual Studio to MonoDevelop. Thanks. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question
Try using this library http://sqlite.phxsoftware.com/ It a complete ADO.NET 2 implementation and it should support the update. On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]> wrote: > I am trying to convert a VB 2005 program from a SQLExpress database to > SQLite 3. I have been successful up to the following line of code: > > Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) > > It seems that the DboTableAdapter does not support the Update command. > What > is the preferred way to update a dataset created from a SQLite db? I am > using CoreLab's dotConnect SQLite data provider. Another consideration is > that my ultimate goal is to move from Visual Studio to MonoDevelop. > > Thanks. > > Dick > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Table Adapter Update Question
I am trying to convert a VB 2005 program from a SQLExpress database to SQLite 3. I have been successful up to the following line of code: Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) It seems that the DboTableAdapter does not support the Update command. What is the preferred way to update a dataset created from a SQLite db? I am using CoreLab's dotConnect SQLite data provider. Another consideration is that my ultimate goal is to move from Visual Studio to MonoDevelop. Thanks. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users