Linq And SQL Metadata Built In Functions?
Jan 13, 2011
So I wanted to check when last a table was changed, and I basically came up with this query:
SELECT DB_name(database_id) as [Database],OBJECT_NAME(object_id ,database_id) AS DatabaseName, last_user_update
FROM sys.dm_db_index_usage_stats
where DB_name(database_id) = 'Database Name'
Now what I want to do is put this in my code using LINQ. I have added the view to my datacontext and all that good stuff, but I don't really know how to do the SQL built in functions DB_Name and OBJECT_Name. I realise that I could do some sort of join to get the values for the id's instead, but I don't know which views I can find the database name and object name in.
Is there a linq equivalent to these functions? Alternatively, what are the system tables/views I need to look at to convert these ID's into their respective names?
View 1 Replies
ADVERTISEMENT
May 14, 2010
i have an application that's in development, but some modules of the application are already built, so the application it's installed in several computers. In my code, i call an external class that i built with several functions that i use in multiple applications, in this class i have a small piece of code that checks in the network (internal), if a new version of the application (Msi File), of the current application it's available, and if it's available, it runs the Msi file.
msiexec /package MSIPackage.msi That worked fine in windows XP, but now some machines have been upgraded to windows 7, and the user need other credentials to run the package. (Elevate Privileges). Other problem it's that in my application i create several folders in the installation and the user doesn't get any permissions to write in the folders.For example i have one Log folder, and i can't write any logs to it.
View 1 Replies
Mar 20, 2012
Are there any built in base number conversion functions in .Net specifically decimal to hex?
View 7 Replies
Jan 11, 2012
I'm trying to load in a xml file that was build using another windows form, but when I try the xml document I get the following error: Name cannot begin with the '%' character, hexadecimal value 0x25. Line 10, position 13.[code]
View 3 Replies
Mar 7, 2012
On the SQL server I create a UDF. Let's name it fnCompanyDetails. It selects some information about a company from several joint tables.I then drag-and-drop this function in the new .dbml of my VB project. I want to use it with LINQ. Smth like this:
[Code]...
View 1 Replies
Oct 30, 2011
How do I pass parameters of LINQ DataTables through Functions and Subs
View 1 Replies
Jun 29, 2010
Is it possible to immediately use code that is built in a dynamically built assembly?I would like to create an instance of an ENUM built using.http:[url]......
View 4 Replies
Dec 6, 2010
What I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
View 1 Replies
Jan 29, 2007
1) Is it possible to access the Excel mathematical functions without actually opening Excel?
I was thinking of through a DLL WinAPI call or maybe a delegate function or smaller program?
2) Does anyone know of a MS link or area that gives instruction on "how to" use every function of every Windows DLL at all?
Or for all those that Microsoft have chosen to document online at least.
View 1 Replies
Feb 17, 2012
I read a lot about changing the metadata of music or images, but what about normal executable? How do I edit the comment / title of them? I am using .NET 2
View 2 Replies
Feb 1, 2010
I am currently trying to create a simple application that will show me the metadata for a wmv file (I'm not trying to get the data for any other video file type at the moment) but I am having some trouble finding a way of doing this.
I have Googled and I have found some downloads that you can get to do this for you, but I would prefer to do this without having to use any third party components. I would have thought that this would be possible maybe through windows media player component or something.
View 1 Replies
Jan 9, 2009
I have some PDF files that my application generates and stores on my machine. Now each file has a persons name and address string related to it in a database. E.g.
Filename | FirstName | Email
The files can be selected within the application UI and emailed out. Now I don't want to have to hit the database each time since there are alot of files. So , how embed the two strings FirstName and Email into the file itself, so when I load it into a FileInfo object there is someway to access the extra data.
View 1 Replies
Jul 22, 2010
I see more than a few questions asking how to read metadata from an image, but I haven't seen as many asking how to write metadata. Basically, I need to add one item of metadata ("ImageDescription") to a PNG image I'm generating dynamically (creating a Bitmap object and procedurally generating all the content in it).
What would be the best way to add metadata to an image with .NET either before or just after writing the file to disk?
View 1 Replies
Feb 1, 2009
1> I want to display the list of table names from database MS Access to vb.net.
2>Also I want to know that under the metadata of MS Access , what other things can i display in vb.net
View 11 Replies
Nov 27, 2010
I'm very new here and I wonder if you can help me with this.I need to get the metadata from an image file, the basic data like Image Type, Image Width,ColorModel, I already found out how to get but there are some that i dont have a clue how to retrieve:
Pixels Depth/Colors , Creation Software (for example Adobe Illustrator ) and ImageResolution (in pixels/dots per inch)
View 2 Replies
Jun 10, 2011
Early on the OP was asked "how will you get the data about your music?" and it went into a whole other direction, but that's what I'm here to show: Another way to get the data about your music without dependence on the metadata.The music that I have has fairly extensive tags embedded but as I've discovered, that's not the case with all of them. It's a good starting point I suppose but is there another way? Let me jump to the end, then in the next several posts, we'll dissect the parts of it. My goal was use "only out of the components and methods" and this is what we end up with: Aside from the rudimentary things like song duration, how about if we could get a host of information about the songs, including the cover art? As shown in the example above, some also will have a link to additional information. The additional information may even contain a way to watch a music video for that song like this: Further, some will even contain what I call "Liner Notes" like this:
If this interests you, read on ...This isn't a new thought at all; I've explored this area before. Have a look at this on Code Project. Now before you go thinking that you've found the keys to the kingdom, I should explain a little minor issue about that - it doesn't work! In that, he relies heavily on three web services: Amazon Web Service MusicBrainz LyricWiki Amazon has significantly modified their service such that his methods don't work now. If you follow the posts following the thread, you'll see a few people have tried workarounds but over the years, even those stopped working because apparently they (Amazon) are in a state of flux regarding their API. LyricWiki is still alive and well, but - the music recording industry forced them to no longer offer their service to developers. MusicBrainz is in fact a heck of a resource and if you're at all interested in this topic, I would encourage you to have a look around. It's odd to work with, but it's chock full of good information and they're constantly adding to it or so it seems. All that said, this example won't use any of those but rather a different service all together: Last Dot FM. I can't say that I know much about them, but I happened onto them a few months back when I was first experimenting with all this stuff.
View 1 Replies
Mar 26, 2012
Is there way to set custom metadata to files of any type? I want the metadata to be copied when the file is renamed, moved or copied. I don't want to use ADS.
View 1 Replies
Nov 8, 2011
Im trying to load the DataBindingLab from MSDN [URL]and im getting the error "Unable to load the metadata for assembly DataBindingLab". Does anyone know how i would be able to resolve this. The next part of the error is "The system cannot find the file specified" but no information as to which file is missing is provided...
View 4 Replies
Feb 1, 2012
I have been looking for weeks for a way to update the exif metadata on a picture. There have been some individuals who tried to help, and there were others who simply referred me to a website, without any knowledge of the problem, or a possible solution.
Now I will take a different approach.
I will PAY for a working library. I want to be able to do these things from the inside of a VB program. Does anyone know of any commercial packages that will allow me to EASILY update the metadata on a picture? I am sure SOMEONE has already done this successfully. I just don't know if these companies wrote their stuff from scratch, or purchased libraries themselves.
View 1 Replies
Oct 4, 2007
I am developing desktop applications using .NET 1.0,1.1 thru VS 2002. I need your help. I want to view/modify file metadata like Author, Title, Company, etc. that file may be a txt / doc / exe / xml / html / pdf any format... I found an example for this in CodeProject site. In that project they give dsofile.dll and source code for viewing/modifying file metadata. I tried to register that dll using regsvr32.exe (regsvr32 dsofile.dll). But it couldn't be registered. even i tried to download setup file from microsoft site but it was not found. Please help me to view/modify file metadata info.
View 9 Replies
May 24, 2011
I'm working a business layer (separate assembly) that will contain various business entities used in multiple client applications. One of the client applications is a WCF app that will need to serialize these entities. In order to properly serialize the entities, metadata for data contracts or for XML serialization must be added, but the serialization requirements may vary across applications.
Clearly I need the metadata separated from the class definition. So how do I add metadata to my entities for each separate application?
View 1 Replies
Oct 12, 2009
why is the datareader closed? I had to change this from a stored procedure to dynamic because our IT guy was encountering trouble changing the sp permissions.. so there's definitely a time factor
Dim cmd3 As New SqlCommand
cmd3.Connection = connect
Dim dr2 As SqlDataReader
[Code]....
View 3 Replies
Oct 6, 2011
I'm using VS2010 Express. I have a VB.net project, where I need to find the metadata of individual files; Artist, Author, Comments, etc. (Specifically I need to find the video length in time of .wtv files). I have searched, but could only find VB6 examples and other code snippets that simply didn't work as they required some retired com or dll to do it. How do I do it in the latest VB.net? NOT VB6, C# or anything else. VB.Net in Visual Studio 2010 Express.
View 20 Replies
Aug 30, 2010
I'm making a (F1) part for my application. I made a form with a Webbrowser-control and I made several .html files. Now I would like that the users enter a keyword and that they see all the files where that keyword is found in the metatag <keyword>. What is the best (and fastest) way to search for that?
View 6 Replies
Apr 18, 2012
I want to make a database of my media collection for my application. I want to create a library for that. Now what i want is that user should be able to add his own song to the database. How can i access mp3 files metadata in my database? How to update that database using my application.
PS: My application is a media player made in Visual Basic using Visual Studio?
View 1 Replies
Oct 8, 2010
Does VB 2010 offer native support for reading and modifying ID3 metadata in MP3 files? A brief search through MSDN shows me nothing, and I see someone says he had to write his own library of code for it. But that was some years ago, when you had to write code to access JPEG Exif metadata, and I know that's changed with the Image class and the GetPropertyItem method; so I'm hoping MP3 files have their own methods and properties now for this.
View 4 Replies
Aug 11, 2010
I'm editing jpg metadata and when I'm finished the file is less than half the size but ok, IE I can see modified tags correctly via windows explorer. But if I edit the same file again its down to 16k and corrupted. The image being edited is the standard desert.jpg found in the picturessample pictures directory.
I'm using the following
Public Sub Put_FileMetadata(ByRef glb_UserArray() As String, ByRef glb_SecurityArray() As String, ByRef glb_InputParms() As String, ByRef glb_InError As Boolean, ByRef glb_ErrorNumArray() As Long, ByRef glb_ErrorDescArray() As String)
On Error GoTo error_handler
' Initialise Variables
[Code] .....
View 2 Replies
Jan 13, 2012
I have a VB.NET project and a C# project in the same VS2010 solution. The VB.NET project is referenced (and used) by the C# project as a project reference. If while I am in the C# project, and I Ctrl-Click or Go to Definition on an element that is part of the VB project, it takes me to C# generated metadata instead of the actual VB code file.Is there any way to get this to go to the VB code file, so I dont have to navigate manually in solution explorer/navigator?
View 2 Replies
Feb 19, 2009
While converting types, I have found myself using both VB functions and BCL Convert.To* methods.
E.g.)
Cstr() vs. Convert.ToString()
CInt() vs. Convert.ToInt32()
CDbl() vs. Convert.ToInt64()
etc...
Are there any subtle differences that should be noted?
View 1 Replies
Mar 4, 2009
Is there a way to see exactly what the functions are doing. What i mean is there a way to see the class? I know what it does, i just want to know the code.
For example the function: Membership.FindUsersByName()
View 1 Replies