I'm quite comfortable with VB and have a very large project i need to do. I've come across SubSonic and it looks awesome. I am not clear if i can use it in VB. I've seen a a couple of posts that suggest they did but on the site it specifically shows C#.Can I use SubSonic with VB.NET?
View 1 RepliesI am trying to get subsonic to run work in a webservice I am not sure how to return the data. I only get the word Object in my results when It return anything instead of values. What am I missing?
<WebMethod(Description:="Method to retrieveCptCode subsonic List")> _
Public Function GetSubCptCodes() As CPTCodeCollection
Dim coll As CPTCodeCollection = New CPTCodeCollection()
Dim qry As Query = New Query(CPTCode.Schema)
coll.LoadAndCloseReader(qry.ExecuteReader())
Return coll
End Function
Followed Rob's webcast, did as he did, watched T4 generate the code, went to use the new namespace and oh. No namespace. I can see the namespace Test.Data in each of the generated .cs files, the tt files are included in the project as is subsonic.dll, there are no errors (I managed to get rid of a warning for the duplicate directives) but I just can't see the namespace. To test it out I am building a simple vb.net console application so wondering if there is a conflict there. Using v2.2 against the same db works fine.
View 1 Replies[code] will both give the error "The method 'CompareString' is not supported". If I make the same call searching for an integer (ID field) it works fine. .SingleOrDefault (Function(x As Account) x.Id = 12)So interger matching is fine but strings don't work Is this a problem with the VB.net templates?
View 3 RepliesI am trying to save changes to a record, however I am getting the error
[code]...
I am using Subonic in a VB.net application for the first time (I have used it succesfully in a WebSite project plenty of times). I followed the 2nd part of the 'Getting Started' video to actually generate the DAL source files as opposed to the build provider method and everything APPEARS to have gone like expected. However, nothing I do will get my generated namespace to appear. I feel that it has to with the fact that I am running my Web Application in VB.Net and Subsonic generates in C#.
Here is the process I followed:
1) I created a blank Web Application Project in Visual Studio
2) I configured the web.config to have the necessary parts, connection strings, etc.
3) I ran subcommander and it generated all the classes I needed into a folder called DAL.
4) I built the Web Application Project
5) I opened up a code behind, typed 'Imports' and I do not see the namespace that was generated.
I have even opened the actual Subsonic Source files and seen that there is a namespace statement for the generated namespace I configured. I tried briefly to move the subsonic files to a separate class library project, compile the .dll and use that in my project, but it still did not work.
I have an application I am converting over from vb6 to vb.net 2.0/3.5. Using Subsonic 2.2 and the vb.net Interop Toolkit 2005. Cannot seem to get the .net form using subsonic to work inside the interop environment.It keeps saying it cannot find the subsonic service provider in the app.config. But I know it is there. Has anyone used these two toolkits together successfully? Will subsonic even work inside the interop environment in that way?
View 1 RepliesI have trouble using the transactionscope on SQLite, i am using the following code. Changes are still commited to the database while i don't call the ts.Complete() function.
Using ts As New System.Transactions.TransactionScope()
Using sharedConnectionScope As New SubSonic.SharedDbConnectionScope()
' Do your individual saves here'
[Code].....
I moved from SubSonic 2.x to 3.0 and noticed that all my classes are combined into the ActiveRecord.vb(cs) file. Is there a way to have my classes generated individually in a separate folder (DAL) as I was doing with 2.x?
View 2 RepliesI need to throw together a quick CRUD asp.net site, but this may become a bigger application down the road. I have some experience with SubSonic, but it has been so long since I did a project with it I have to relearn it. I am also considering using Dynamic Data.
View 5 RepliesI'm trying to use Subsonic 3.0.0.3 with an existing web site created in vb.net. I've added a reference to SubSonic.Core.dll and added the ActiveRecord tt/ttinclude files. I also added a contextmenu entry to run the t4 templates using instructions I found here.Whenever I try to run any of the tt files, I receive the following exception. Does this have something to do with me using a web site as opposed to a web application?
f:Documents and SettingsdbollardLocal SettingsTempSQLServer.ttinclude(85,15) : warning CS0219: Compiling transformation: The variable 'parameters' is assigned but its value is never used
ActiveRecord.tt(0,0) : error : Running transformation: System.InvalidCastException: Unable to cast object of type 'Microsoft.VisualStudio.TextTemplating.CommandLine.CommandLineHost' to type 'System.IServiceProvider'.
[Code]...
i download subsonic 3 today (subsonic 3 preview 2) but this don't work in vb project.i think because .tt file (for generation) is C# template so this don't generate vb code.
View 1 RepliesSubsonic 2.2 is throwing the error
subsonic Invalid cast from System.Int32 to System.Byte[]
When I do the following
If template.Content Is Nothing Then
MsgBox("Blank Document")
Else
MsgBox("Document Present")
End If
"template" is a SubSonic object of which it's "content" field is of type Byte()
write SubSonic 3 Step By Step WinForm App VB.Net: Installation,Setup And Generating.
View 2 Replies